Checkboxes and Query Criteria

[adam.vogg]

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?

 

[adam.vogg]

Nevermind, i solved it.

I set criteria to this:

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


Seems to be working as planned.