Access 2002 Programming by Example

Using a Parameterized Query As a Form’s Record Source

A query that prompts the user to enter information is called a parameter query. The information that is entered in turn become criteria in the query. You enter the prompt enclosed in brackets (as if it were a field) in whatever field or fields you want to add criteria. After the query is ready, you can attach it to a form as a record source. Let’s say that your coworker wants to add criteria to a query so that the user can open the form displaying the claims for whatever state was selected. You then could add another parameter to make the query select date ranges. After selecting the parameters, the user can browse the records of selected data. All this can be done with very little effort. ...