Yes/No query from form.

[Weezie1383]

Greetings all,

I am attempting to create what seems (to me at least) to be a very complex
query. I have a form (which will eventually link to my query when I can
figure out what I'm doing). The form has 4 yes/no check boxes, and two combo
boxes.

What I would like to do is have a user of my database select one of the
check boxes (hence filtering for any checked record in my table) and then
make a choice from each of the two combo boxes which would then filter the
search results just to those choices selected.

Any help would be greatly appreciated!

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The article explains how to do this by creating a filter for your form,
based on the criteria the user entered.