Parameter when checkbox?

[Guest]

Hello!
This might be a silly question but;
How do I make a criteria question when I got a checkbox?
If I type "<[Yes or no]" in the criteria field I just get an error saying
something like:

"This expression is written false, or is maybe too complicated to evaluate"

Someone got an answer, or does it simply not work to have a criteria
question when you are using checkbox?

I would be happy for any answer!
Best wishes from Jorgen

 

[Allen Browne]

Use 0 for False, or -1 for True.

Alternatively, place a check box on a form, and refer to:
[Forms].[Form1].[Checkbox2]
or whatever instead of the [Yes or No] parameter.

It also helps JET to understand the value if you declare the parameter by
choosing Parameters on the Query menu (in query design view.)