How to Filter in Query a Triple State Check Box

[doyle60]

I like to put filters on queries that will return all records if the
form control is null. For a text filter, I use something like this:

Like (IIf(IsNull([Forms]![DDShipmentPrintfrm]!
[CountryChosen]),"*","|[Forms]![DDShipmentPrintfrm]!
[CountryChosen]|"))

But what would be the criteria row code for a triple state check box on
a form (where the third and gray state returns all)?

Thanks,

Matt

 

[Alex Dybenko]

try (assuming your field called Shipped and checkbok - chkShipped):

(Shipped = Forms!MyForm!chkShipped or Forms!MyForm!chkShipped is null)

 

[doyle60]

Thanks. But it didn't work. But I turned it around to:

(Shipped = Forms!MyForm!chkShipped is null or
Forms!MyForm!chkShipped)

and that did the trick. Thanks,

Matt