ACC2000: Access Prompts You to Save Form After You Use the Code Builder

• Microsoft Access 2000

SYMPTOMS

Access prompts you to save changes when you close a form or a report even though you did not make any design changes.

CAUSE

You used the Code builder to view the module of the form or the report. When you use the Code builder to view a form or a report module, the builder always marks the form as dirty even if you did not make any design changes. When you close the form or the report, Microsoft Access prompts you to save it.

RESOLUTION

To avoid the save prompt when you want to view a form or report module, do not use the Code builder. Instead, use one of the following methods to view the form or report module.

Method 1: Use the Code command on the View Menu

1. Start Microsoft Access 2000.



2. Open the sample database Northwind.mdb.



3. Open the Employees form in Design view.



4. On the View menu, click Code to view the module of the form.



5. Browse to the procedure that you want to view.



6. Close the Visual Basic Editor without making any changes, and then return to Microsoft Access.



7. Close the Employees form without making any changes.

Method 2: View the Module from the Project Explorer in the Visual Basic Editor

1. Start Microsoft Access 2000.



2. Open the sample database Northwind.mdb.



3. Open the Employees form in Design view.



4. On the Tools menu, point to Macro, and then click Visual Basic Editor.



5. On the View menu, click Project Explorer.



6. In the Project Explorer, expand the Microsoft Access Class Objects folder under your database.



7. Locate the form or report module that you want to view, and then double-click to open it.



8. Browse to the procedure that you want to view.



9. Close the Visual Basic Editor without making any changes, and then return to Microsoft Access.



10. Close the Employees form without making any changes.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

1. Repeat steps 1 through 3 of either method in the "Resolution" section earlier in this article.



2. On the View menu, click Properties to display the property sheet.



3. On the Edit menu, click Select Form.



4. In the property sheet, click the Event tab.



5. Click in the AfterUpdate property box. Note that it is set to [Event Procedure].



6. Click the Build (...) button to the right of the property box. Note that this invokes the Visual Basic Editor and displays the code for the AfterUpdate event of the form.



7. Close the Visual Basic Editor without making any changes, and then return to Microsoft Access.



8. Close the Employees form without making any changes.

Additional query words: pra

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug