Checkboxes and Query Criteria

  • Thread starter Thread starter adam.vogg
  • Start date Start date
A

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?
 
Nevermind, i solved it.

I set criteria to this:

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


Seems to be working as planned.
 
Back
Top