Query parameter for combo box from another combo

[sam93]

Hi,

I have a combo box (say cmbB) in a form that needs to get populated through a parameterized query. The query parameter comes from another combo box (say cmbA).

I have included a WHERE clause in my query to get value from the combo box (cmbA).
But when I change my selection in the first combo box (cmbA), the other combo box (cmbB) is not refreshed; i.e. the query associated with it does not get associated.

How can I execute the query to refresh cmbB whenever I change selection in cmbA?

Thanks.

 

[PHV]

In the AfterUpdate event procedure of cmbA reset the RowSource property of cmbB.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886