Multiple criteria query

[DJ-Specter]

Hi I have a range of forms tables and queries listing people with individual profiles i.e. ages 16-24, 25-34, gender m, gender f, disabilties etc. I currently have a master form that has command buttons with each of the above profiling methods that when clicked on brings up another form listing all conforming clients.

My problem is how to, using a simple interfact allow a user to search for users with more than one criteria, i.e. all males aged 35-44 with diabetes.

I was thinking about turning the command buttons into toggle buttons so when one gets pressed, it includes a specific table in the query.

Help!


Thanks

[dcrake]

See AWF for sollutions/suggestions.