I am attempting to pass boolean information provided by the user in a check box into the query criteria. If the user has checked the box, I want the query criteria to be true. I seem to have that part of this working. But if the user has not checked a box, I do not want the query criteria to necessarily be false (it could just mean that the user does not care about that criterion). So if the check box is unchecked, I want the query criteria to be empty or wild card, such that it will accept either a true or a false boolean value.
This is the code that I have so far, entered on the criteria line in the query design view.
IIf([Forms]![PlanBuilder]![chkActiveSearch],True,Null)
This is needed because the user has access to several check boxes. I want to return to them data that has the same boxes checked that they have checked in the search criteria AND any other records that might have additional boxes checked. In other words, the data returned need not have an exact match on all the empty check boxes in the user search criteria.