Dynamically set the row source of a combobox???

[Richie27]

Hi all,

I have a combobox filter on a mainform.

I have a combobox filter on a subform - the values of which are derived from a hard coded query.

Is it possible to change the row source of the subform combo based on what is clicked on in the mainform combobox filter? I also want to be able to clear the combo's rowsource completely - when add new record is clicked.





Mucho, mucho Gratias



Rich.

[R_Badger]

You can dynamically change the rowsource of a combobox using vb.
[control_name].rowsource= "String here for full sql statement"

To clear it use
[control_name]=null

[Richie27]

Oh my word, you are a life saver!

You were helping me with this before - my communication must have been poor!!

Thanks a million!