Not sure I can do this.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

What I would like is a form with a combo box to filter a query. That I have
so far. But then I would like a series of check boxes. If one check box is
checked it filters for that check box in addition to my combo box. Where I
am getting hung up is each check box on the form has a matching boolean field
in the record. I have tried setting up the query for each check box to link
to the check box on the form. The trouble seems to be it can't be blank. I
get nothing when I query. So, I think I need to link only the check box I am
filtering to, which is variable. Can I place the link through VB onto the
query from the form based on which check box is selected?

Thanks
 
I check box can have two values , True and False, so if you didn't check it
you need to filter on false.

In that case try and use
Where field = NZ(Forms![FormName]![FieldName],0)

But if you want to select all the values if you didnt check the box, try and
use
Where field Like NZ(Forms![FormName]![FieldName],"*")
 
Hi John,

That is why I used check boxes but am having trouble filtering by them. See
my earlier postings. I take it then, there isn't a way to filter these
check boxes?
 
Back
Top