Checkboxes and Query Criteria



So i have a form with checkboxes, and I want the query criteria to be
based on those checkboxes. However, if the checkbox = No, I want the
query criteria to Yes or No for that field (or "*").

I was able to do something similar with the Nz() Function where if a
textbox was Null, then criteria = "*".

Need to do something similar with these checkboxes.

So, if checkbox = Yes, criteria = Yes, if checkbox = No, then criteria
should not filter anything out.

Any ideas?


Nevermind, i solved it.

I set criteria to this:

Like IIf([forms]![frmSearch].[checkbox1].[value]=-1,-1,"*")

Seems to be working as planned.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads