Executing a Parameter Query

Suppose you want to run a query named Invoices Filter that looks like the one shown in the Query grid in Figure 15-2.

Figure 15-2: A parameter query can be based on a value supplied by a field placed on an Access form.

Because the query is linked to the OrderID field located on the Orders form and the Orders form is closed, you are prompted to enter the parameter value before the query can be executed.

Part II

Figure 15-3: When you execute a parameter query, a dialog box displays an input box to enter the value of the required parameter.

The procedure in Hands-On 15-5 shows how to run this sort of a query by using ADO.

0 0

Post a comment