Filtering a query from a form

[Guest]

Hi,
I would linke to know how to create a form where a user can bring view
records in a query (as a sub form in datasheet view). I would like the user
to be able to select criteria from different list boxes and have the
appropriate data displayed in the subform. I would also like to be able to
filter the query by more than one list box if it is selected. Is there any
advice on how to create this?

 

[Guest]

Ben:

When you design the query, you will want to set criteria to reference the
list box(es) on your form, so that the query uses the initial responses to
determine data for your sub form. You will also need to requery, the sub
form, once the user has made their selections.

Good luck.

Sharkbyte