How to Filter in Query a Triple State Check Box

  • Thread starter Thread starter doyle60
  • Start date Start date
D

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
 
try (assuming your field called Shipped and checkbok - chkShipped):

(Shipped = Forms!MyForm!chkShipped or Forms!MyForm!chkShipped is null)
 
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
 
Back
Top