Refining Queries  «Prev 

Creating parameter queries using Microsoft Access

  1. Here is a query that displays all the company names and the states they are located in. You are going to add a parameter that will ask the user to enter a specific state, and return the results. In the first Criteria row for the State column, type [Enter State:], then click the View toolbar button to execute the query.
  2. Here is the parameter box you created. Type in TX, then click the OK button.
  3. There you go. The companies that are located in Texas are now displayed.
The view will need to display the result of matches, filtered to the username. Because it will be a popup view, we can use a parameter query to supply the username.