How to show both Yes/No in a query?

[PerryC]

I have a query and a InputForm.

Query:
Field1 (Yes/No)
Forms![InputForm].[CheckBox]

What I wanted: If user do not click CheckBox, Query will show ONLY the
No records; however, if Users check that Checkbox, it shows BOTH the
YES/NO records. (Bear with me on this poor explaination)

Sincerely,
Perry

[Steve Jorgensen]

On 9 Nov 2004 06:35:37 -0800, pe******@yahoo.com (PerryC) wrote:

I have a query and a InputForm.

Query:
Field1 (Yes/No)
Forms![InputForm].[CheckBox]

What I wanted: If user do not click CheckBox, Query will show ONLY the
No records; however, if Users check that Checkbox, it shows BOTH the
YES/NO records. (Bear with me on this poor explaination)

Sincerely,
Perry

To do it with a single query, the key is that you always want No records, so
the condition is that the record is No or the checkbox is unchecked. That
means a record will only be excluded if it is Yes, and the checkbox is
unchecked.

SELECT tblMyTable.* FROM tblMyTable WHERE tblMyTable.Field1=False OR
[Forms]![InputForm].[CheckBox]=False

[Perry Cheng]

Thanks a lot. That works perfectly.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!