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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top