Access Forms

[jadown]

I designed a form that has job titles and a dropdownlist to select the state. Each job title has a checkbox. I built a query to query a table (tblPostions) which contains the following:

Positions
Hourly Rate
City
State

The other table (tblState) just has a list of all the states in the U.S. The query that I have made pulls back all the fields from tblPositions according to the state selected from the dropdownlist. I was wondering if there is a way to have only the checked positions pulled back when the query runs?

[Denburt]

If you look at the SQL for the query it should like something like this.

Select Positions, Hourly Rate,City,State from tblPostions

Adding a where clause should solve the issue

Select Positions, Hourly Rate,City,State from tblPostions Where [job title] = true

[Nathan H]

I designed a form that has job titles and a dropdownlist to select the state. Each job title has a checkbox. I built a query to query a table (tblPostions) which contains the following:

Positions
Hourly Rate
City
State

The other table (tblState) just has a list of all the states in the U.S. The query that I have made pulls back all the fields from tblPositions according to the state selected from the dropdownlist. I was wondering if there is a way to have only the checked positions pulled back when the query runs?

Add the checkbox field to your query and then in the criteria line put YES. (You may have to try TRUE or ON depending on the format of your checkbox)