BUG: Enter Parameter Value Dialog Box Appears While Trying to Close a Form Window (811860)



The information in this article applies to:

  • Microsoft Access 2002
  • Microsoft Access 2000
  • Microsoft Windows XP Professional
  • Microsoft Windows XP Home Edition

SYMPTOMS

When you click the Exit button that runs the DoCmd.Close Microsoft Visual Basic for Applications (VBA) code, an Enter Parameter Value dialog box may appear. This occurs when you close a form window in Access that runs with the Windows XP operating system.

WORKAROUND

To work around this problem, perform one of the following tasks:
  • Click Close (X) in the upper right corner of the form window.
  • Click Restore Down in the upper right corner of the form window and then click Exit. This runs the DoCmd.Close VBA code.
  • Turn the Echo method off before you issue the Close statement. Then, turn the Echo on again. For example, change
    DoCmd.Close
    -to-
    DoCmd.Echo False
    DoCmd.Close
    DoCmd.Echo True

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

283166 ACC2000: You Are Prompted to Enter a Parameter Value for the Trim Function While Previewing a Mailing Label Report

301545 ACC2000: "Enter Parameter Value" Dialog Box Appears When You Run Query, Form, or Report

303134 ACC2002: "Enter Parameter Value" Dialog Box Appears When You Run a Query, a Form, or a Report

282360 ACC2002: "Enter Parameter Value" Dialog Box Displays Square Brackets Around Parameter "Name"

298877 ACC2002: Parameter Dialog Box Appears When You Run a Pasted Query

275063 ACC2002: Name AutoCorrect Does Not Repair Certain Form or Report Property Settings


Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbBug KB811860 kbAudDeveloper kbAudEndUser