Is there a way to use check boxes for query parameters?

G

Guest

Hi, I am trying to create a parameter query. I have a databse with names and
counties that the people live in. I want a query that will allow you to
select one or more counties and display the names of the people who live in
the counties. I was also wondering if a checkbox method could be used to
allow for one or more counties to be selected without relying on the end-user
to correctly enter the name of each desired county
 
G

Guest

The value of a checkbox is zero for unchecked or false. It is minus one for
checked or true.
Use the checkbox in your query by entering this in the design view grid,
FIELD row --
X: [Forms]![YourForm]![YourCheckBox]

In the criteria row put -1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using field name as value in query 2
How to eliminate rows with redundant values and keep other values? 1
what is the criteria to look up more than 1 Value in a field 6
how do i set multiple criteria in a query 1
Using check boxes to set criteria 3
Query help 3
synchronized Combo Boxes in subforms 2
Need help sorting out ANDs and ORs in parameter query 2

Top