Adding a check box to a form for a query

[Jim W]

I have a query that run based off data entered on a form. In the table that I query their is a field called Service Type. 1 of the selections for service type is "Scheduled Down" Now on this form I want to add a check box field so that if checked then the query will exclude all "Scheduled Downs" and if unchecked then it would include all. Can this be done?

Jim

 

[Jim W]

I can use 2 different queries to do this based off if the check box If chenked run query 1 else query 2
but this will add alot of queries. Is there a better way?

Jim

 

[Thecherub]

This might help

I think that the best way to do it is with 2 Queries on to Display the only the Checked records on one to display all. The other way is to force user entry.

Like:[yes/no]

that will give you either or with one query i'm not sure how to use that to give you all of the records though.....

The Cherub