Parameter when checkbox?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jorgen - 30 May 2006 11:52 GMT

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

Reply to this Message

Allen Browne - 30 May 2006 12:48 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello!
> This might be a silly question but;
[quoted text clipped - 10 lines]
> I would be happy for any answer!
> Best wishes from Jorgen

Reply to this Message