list provided for query

[Graham Bucknall]

I have a large database containing a variety of information about firms. I have 7 different fields each of which relates to a user type eg youth, women etc.
I want to set up a query where the user clicks a button "Search by user type" and then another "box" opens up with a list of the 7 different type, the user chooses them and then the search is carried out.
Ideally I would prefer a list of the 7, a check box by each and then a multiple search.

Does anyone have any suggestions?

Many thanks

 

[Pat Hartman]

Use a form with a multi-select listbox. If you search, you should find code examples. This one may help.