• Microsoft Access Parameter Query Drop Down List
• Microsoft Access Query Prompt

Now, go back to Datasheet view to run the query. Access now prompts you for values for your parameter in a dialogue box, as shown below: Enter the Start Date for the query. Enter an End Date. Access now shows us the results of our query: Changing Parameter Prompt Order. MS Access – VBA – Run Parameter Query in VBA. What is a parameter? In a query, we can specify a criteria. In most instances, the criteria will be a static value. That said, it become necessary in many instances to make these criteria dynamic, and to do this there are different methods, but one common approach is to refer to a control on a form. Getting a Value from a Form for Query Criteria in MS Access - Duration: 7:28. PC Learning Zone - Computer Training 137,299 views.

When you want a query in Access to ask for input every time that you run it, you can create a parameter query.

• Include parameter values in your Access report titles by Mary Richardson in Microsoft Office, in Software on April 28, 2009, 5:47 AM PST.
• Microsoft Access Tips & Tricks: Parameter Queries Parameter queries are a powerful feature of Microsoft Access that enables query designers to write a query once, and use it for various purposes. The way this is accomplished is to make the query interactive, so that important aspects of the query's functioning can be provided to the query at run-time.

You can also create a form to collect parameter values that will be used to restrict the records returned for queries, forms or reports. This article explains how to use forms to enhance your use of parameters in queries, forms, and reports.

In this article

Overview

You can use criteria in a parameter query in Access to restrict the set of records that the query returns. You may find the dialog boxes that are provided by a parameter query to be insufficient for your purposes. In such cases, you can create a form that better meets your parameter collection needs. This article explains how to create a form that collects query and report parameters. This article assumes that you are familiar with creating queries and defining parameters in queries. At a minimum, you should be familiar with creating a select query before you continue.

This article provides examples of using parameters in queries. It does not provide a comprehensive reference for specifying criteria.

• For more information about how to create a select query, see the article Create a simple select query.
• For more information about queries in general, see the article Introduction to queries.
• For more information defining parameters in queries, see the article Use parameters to ask for input when running a query.
• For more information about how to specify criteria in queries, see the article Examples of query criteria.

Use parameters in queries

Using a parameter in a query is as easy as creating a query that uses criteria. You can design a query to prompt you for one piece of information, such as a part number, or for more than one piece of information, such as two dates. For each parameter, a parameter query displays a separate dialog box that prompts you for a value for that parameter.

Add a parameter to a query

1. Create a select query, and then open the query in Design view.
2. In the Criteria row of a field for which you want a parameter applied, type the text that you want the parameter dialog box to display, enclosed in square brackets, for example:
   [Start Date]
   When you run the parameter query, the prompt appears in a dialog box without the square brackets.
   You can also use an expression with your parameter prompts, for example:
   Between [Start Date] And [End Date]
   Note: A separate dialog box appears for each parameter prompt. In the second example, two dialog boxes appear: one for Start Date and one for End Date.
3. Repeat step 2 for each field that you want to add parameters to.

You can use the preceding steps to add a parameter to any one of the following types of queries: Select, Crosstab, Append, Make-table, or Update.

You can also add a parameter to a union query by following these steps:

1. Open the union query in SQL view.
2. Add a WHERE clause that contains each of the fields for which you want to prompt for a parameter.
   If a WHERE clause already exists, check to see whether the fields for which you want to use a parameter prompt are already in the clause, and if not, add them.
3. Instead of using a criterion in the WHERE clause, use a parameter prompt.

Specify parameter data types

You can also specify what type of data a parameter should accept. You can specify the data type for any parameter, but it is especially important to specify the data type for numeric, currency, or date/time data. When you specify the data type that a parameter should accept, users see a more helpful error message if they enter the wrong type of data, such as entering text when currency is expected.