Microsoft KB Archive/302690

= ACC97: &quot;Enter Parameter Value&quot; Dialog Box Appears When You Run a Query, Form, or Report =

Article ID: 302690

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



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.
 * 1) Click Options, specify which options of the selected object you want to search through, and then click OK.
 * 2) Click OK.
 * 3) On the File menu, click Export.
 * 4) Under Save as type, click Text Files, and then complete the remainder of the information as needed.
 * 5) 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.

Additional query words: prb

Keywords: kbprb KB302690

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.