ACC97: "Enter Parameter Value" Dialog Box Appears When You Run a Query, Form, or Report (302690)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q302690
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

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

CAUSE

This behavior can occur if a field, criterion, expression, or control within a query, form, or report references an object that Access cannot find. For example, a name might be misspelled, or a field might not be available in that scope.

RESOLUTION

To resolve this behavior, run the Database Documenter for the database object that you were using when the Enter Parameter Value dialog box appeared. Export the report as a text file, and then search for the parameter that Access cannot find:
  1. On the Tools menu, point to Analyze, and then click Documenter.
  2. Click the tab that corresponds to the kind of database object, and then click to select the check box of the query, form, or report that you want to run.

    If the object is a form or report, include all source queries and subforms or subreports in your list of selections.
  3. Click Options, specify which options of the selected object you want to search through, and then click OK.
  4. Click OK.
  5. On the File menu, click Export.
  6. Under Save as type, click Text Files, and then complete the remainder of the information as needed.
  7. Open the exported file in Microsoft Word, and then perform a search for the parameter that is requested in the Enter Parameter Value dialog box.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB302690
©2003 Microsoft Corporation. All rights reserved.