ACC: You Are Prompted Twice for Same Query Parameter Value

MORE INFORMATION

This behavior occurs only if you already have the query open and in the filtered state when you switch to Design view. If you open the query directly from the Database window, you receive only one prompt for the parameter. Microsoft Access prompts you for the parameter again when you apply the filter by clicking the Apply Filter button on the Query Datasheet toolbar or by clicking the Apply Filter/Sort command on the Records menu.

Steps to Reproduce Behavior

1. Start Microsoft Access and open the sample database Northwind.mdb.
2. Create the following new query based on the Employees table:
   

         Query: qryDblPrompt
         --------------------------
         Type: Select Query
   
         Field: FirstName
            Table: Employees
         Field: LastName
            Table: Employees
         Field: Title
            Table: Employees
         Field: HireDate
            Table: Employees
            Criteria: > [Enter Date]
   						

3. Right-click in the top half of the QBE grid, and then click Properties.
4. In the Query Properties dialog box, enter the following for the Filter property:
   

         [Title] = "Sales Representative"
   						

5. Save the query as qryDblPrompt.
6. Run the query, and when the parameter prompt appears, enter the date 1/1/94.
7. On the Records menu, click Apply Filter/Sort.
8. When the parameter prompt appears, enter the date 1/1/94.
9. On the View menu, click Design view (or Query Design in version 7.0). Then on the View menu, click Datasheet view (or Datasheet in version 7.0).
   
   Note that Microsoft Access prompts you twice for the same parameter value.