Thanks in advance and helping me expand my Access knowledge. Anyway I have 39 check boxes and what I want is when I run my query is to have the query check the values that are checked true and run those through my query. I have a button trigger on my FORM to run the query, however I am not sure the code syntex that I will need to accomplish this. Any help will be appreciated.


Thanks


PS (I did figure out how to do a select all and select none button)

In Access, a checkbox that is not checked produces a 0 and a checkbox that is checked produces a 1.

So you can set the criteria of each checkbox field in the query to -1 and it will find those that are checked.

There should be a selection on the button wizard to run the query for you.