I have a form with checkboxes to filter a query. One of the checkboxes is for filtering the query to find null entries.
Here's the code I put into the Criteria field in my query:
I read that IF statements don't like the input of null, but I couldn't figure out how else to connect the checkbox to filter null entries.Code:IIf([Forms]![MyForm]![A]=True,"Is Null") Or IIf([Forms]![MyForm]![B]=True,"3A")
Any help is much appreciated! Thanks in advance!