Parameter when checkbox?

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

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
 
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.)
 
Back
Top