Course summary: Use parameter queries to filter query results

In a desktop database

  • Build your query, then add parameters. You can add them to Select, Make Table, Append, Update, Crosstab, and Union queries.
  • With the query in Design view, click Parameters (Design tab), enter the parameter, choose a data type, click OK. Then add the same parameter (a.k.a. an identifier) to the Criteria row of the field you want to filter. Enclose second parameter in square brackets.

In a Union query

Add a clause after each FROM statement: WHERE [field name] = [your parameter]. Use the same parameter in each clause.

In an Access App

Add your parameter to the Query Parameters dialog first, then place it on the Criteria row. No spaces in parameters or the query fails. Remember, Apps use different wildcards than desktop databases.

Build the first view

Use a blank view with no data source. Add text boxes, apply date/time format, add labels, button, give the controls names, add formatting to taste.

Build the second view

Home> Advanced> Datasheet View. Click Data, select your Parameter query, click Show only fields in the current record source, drag the fields to the view.

Build the macro

On the first view, click the button > Actions> On Click> Open Popup. Under Parameters, enter the name(s) of the text box(es) on the first form, surrounded by square brackets. Save, close, save the database, then Launch App.

See also

 
 
Applies to:
Access 2013