How combo box row source query be conditional on another control

[Guest]

I want to make my row source query conditional on the (dynamic) value of
another control in my form. Pls help.

 

[Guest]

Just filter the query in row source of the combo with the field in the form

Select * From MyTable Where MyField = forms![FormName]![FieldName]

On the after update event of the field in the form referesh the source of
the combo,
Enter the code
me.comboName.requery

Also if you move between records in that form, then run the requery for the
combo in the on current event of the form

 

[Guest]

Thanks for your help, Ofer.

Just filter the query in row source of the combo with the field in the form

Select * From MyTable Where MyField = forms![FormName]![FieldName]

On the after update event of the field in the form referesh the source of
the combo,
Enter the code
me.comboName.requery

Also if you move between records in that form, then run the requery for the
combo in the on current event of the form

I want to make my row source query conditional on the (dynamic) value of
another control in my form. Pls help.