How do you use check boxes in user input fields for queries

J

Jamil Afza

I am trying to set up a query in which the user has to bring up records
according to a yes/no field. I tried to use the brackets to indicate a user
input when the query starts up but no matter what I type in the field it
keeps giving me an error (i tired yes, "yes", 1, no, "no", 0). Is there a way
that I could have the user check or uncheck the box for yes or no instead of
having to type something in? Any help would be greatly appreciated.
 
S

SusanV

You can also use =True for checked fields and =False for unchecked fields,
if that's easier to remember...
 
Top