ACC2000: Resetting Code in Visual Basic Editor Causes Problems with Wizards

If you switch from the Access user interface to the Visual Basic Editor while a wizard is running, and you click Reset on the Run menu or you click the Reset button on the toolbar, the wizard stops responding, or you receive any the following error messages. These error messages may be repeated several times. When you close all the error messages, some or all of the controls in the wizard may be empty. You may also see the errors when you click or move the mouse pointer over a control in the wizard.

In the Visual Basic Editor, you clicked Reset on the Run menu or you clicked the Reset button on the toolbar while a wizard was running.

Click Cancel, and then restart the wizard.

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

The behavior described in the "Symptoms" section occurs with the following wizards:

• Chart Wizard
• Crosstab Query Wizard
• Find Duplicates Query Wizard
• Find Unmatched Query Wizard
• Form Wizard
• Label Wizard
• Page Wizard
• PivotTable Wizard
• Report Wizard
• Simple Query Wizard
• Table Wizard

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.
2. In the Database window, click Forms under Objects, and then double-click Create form by using wizard.
3. Press ALT+F11 to start the Visual Basic Editor.
4. On the Run menu, click Reset.
5. On the File menu, click Close and Return to Microsoft Access.

Note that you receive some of the error messages mentioned in the "Symptoms" section and that the controls on the Form Wizard are blank.