Subform / Combo Query

[Saifon]

Hi Folks

Attached is an example of what I'm looking to do.. I'm new to VB code and not great on queries either.

I'm looking to simply choose the department from the dropdown combo box on the form and the subform above it to update with showing all the results containing the department from the selection.

Not sure on the best way to do this, either via a query or from the table directly, or even some way to use the drop down to filter the table being displayed on the subform.

Anyone got any ideas. Thanks

 

[Pat Hartman]

The subform's RecordSource query should reference the combo for its selection criteria. Then in the AfterUpdate event of the combo, you need to requery the subform.

 

[Saifon]

got it.. cheers thanks..