Querying on a form based on checkboxes

[Menes]

Struggling with creating a search function on a form using checkboxes. I'm trying to create a form where I can tick the boxes for datasets, for example, 1 and 3 out of 5 and the query will return anyone in the database who has those two ticked, whether it is just one of them or both or them.

I've managed to produce a similar query before based on textboxes but I'm struggling to solve the issues for check boxes. It has to be able to handle the OR ability in that it could be any combination of the five to produce a list of email address to send out updates.

If any could provide any help or point me to a example on another site, it would be very much appreciated.

Many thanks

 

[chrisguk]

A check box can be stored in a table as the following:

Yes or No

1 or 0

True or false

Essentially its a switch and my guess is that your tables are not normalised correctly or you are searching for the wrong value in your query.