Form Check Box Query

[mercwonder]

I have a form that has unbound check boxes on it. They are linked to a query. The query has the following script in the criteria section

[Forms]![frmTEST]![Check0]

This is set up so that when I put a check in the checkbox and press the control button it envokes the query. I have 6 boxes on the form with the same script for the exception of the [Check0] number.

Right now the way it is set up I have to check the exact sequence in order to get any data. Is there a way that I can simply check a box and pull up all the records that are checked. (Ex. I check "Box 1" and push the control button. I want it then to show me all the records that have a check in "Box 1" regardless of what the other check boxes are.) So far I have not found a way to do this.

 

[Jon K]

On the unbound form, you can set the Triple State of each check box to Yes so that the check boxes can be checked, unchecked or grayed.


See the query in the attached database.
.

 

[mercwonder]

Thank You

Thank you. It works great. Is there a way to get the same outcome without using the "Triple State"?