Dynamically Combobox values

[myuser]

Hi,

I have a combobox that I want to fill its value dynamically.
I write:

if ........ then
combobox1.rowsource="Select specialist from table1"
elseif
combobox1.rowsource="Select specialist from table2"
endif

but when I run the form, the combobox value is the SQL statement, like (Select specialist from table1) not the result of sql statement.

I am getting crazy!
plz help me

 

[JHB]

Have you remembered to set the "Row Source Type" to "Table/Query"?

 

[myuser]

Thank you JHB, That was the solution.