Filtering question

[JB_96RS]

What would be the best way to filter a query in a subform? I want to use a combo box or a check box to filter the results. I am trying to make this easier than using the filter in the toolbar... need to make it simple for the pc noobs.


Thanks,

JB

 

[dcx693]

How about clicking on the "Filter by Selection" or "Filter By Form" buttons on the toolbar?

 

[theprez]

Make the criteria of the query of the subform based on the Combo box or check box. Use the AfterUpdate event of the combo or check box to requery the subform.

For instance in the query let's say you want the query to be based on a customer selected in the combo box which is on a form called main.

The query will have a field called customerID. Make the criteria of customerID equal to Form![Main]![Combo Box]. This tells the query to only display customers in the query that equal the customer in the combo box.

Hope this helps and is not too confusing