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

[Guest]

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.

 

[Joseph Meehan]

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.

Yes = -1
No = 0

 

[SusanV]

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