Creating parameter queries using Microsoft Access
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.
- 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.
- Here is the parameter box you created. Type in TX, then click the OK button.
- There you go. The companies that are located in Texas are now displayed.