"Enter Parameter Value" dialog box appears when you run a query, a form, or a report (303134)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
This article was previously published under Q303134
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2000 version of this article, see 301545.
For a Microsoft Access 97 version of this article, see 302690.

SYMPTOMS

When you try to run a query, a form, or a report, the Enter Parameter Value dialog box may appear unexpectedly.

CAUSE

This behavior occurs when a field, a criteria, an expression, or a control in a query, a form, or a report references a name that Access cannot find. For example, a name could be misspelled or a field may not be available within that scope.

RESOLUTION

To resolve this behavior, rename the reference to a valid field name. If you do not know where the reference is located, run the Database Documenter for the object listed in the Enter Parameter Value dialog box, and then output the information to a text file. To do so, follow these steps:
  1. On the Tools menu, point to Analyze, and then click Documenter.
  2. Click the tab that corresponds to the type of database object that you are looking for, and then click to select the check box of the query, the form, or the report that you tried to run.

    NOTE: If the object is a form or a report, include all source queries and subforms or subreports in your list of selections.
  3. Click Options to specify which feature of the selected object you want to print, and then click OK.
  4. Click OK to close the Documenter dialog box.
  5. On the File menu, click Export.
  6. In the Save as type list, click Text Files, and then complete the remainder of the information as needed.
  7. Open the exported file in Microsoft Word, and then search for the parameter requested in the Enter Parameter Value dialog box.
If you cannot run the Database Documenter, check to see if there is a missing reference. The most common missing reference in this case is to the Utility.mda. To check for this reference, follow these steps:
  1. In the Database window, click Modules under Objects.
  2. Select any existing module, and then click Design or insert a new module. This will start the Visual Basic Editor.
  3. On the Tools menu, click References.
  4. In the Available References list, look for any reference that has "MISSING: " in front of the name. Click to clear the check box.

    NOTE: If you do not need a reference to Utility.mda, skip to step 8.
  5. Click Browse.
  6. In the Files of type list, click Add-ins (*.mda).
  7. Browse to the folder that contains Utility.mda, select it, and then click Open. By default, this file is in the folder C:\Program Files\Microsoft Office\Office\1033.
  8. Click OK.
  9. On the Debug menu, click Compile database name.
  10. On the File menu, click Close and Return to Microsoft Access.

MORE INFORMATION

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. Open the Order Subtotals query in Design view.
  3. Rename the OrderID field to OrderIDNumber.
  4. Close the query, and then click Yes to save the changes.
  5. Run the Order Subtotals query.
  6. Note that the Enter Parameter Value dialog box appears.
Modification Type:MinorLast Reviewed:6/9/2004
Keywords:kbReport kbprb KB303134 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.