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

MORE INFORMATION

The AutoCorrect feature in Microsoft Access 2002 does not fix or repair certain property settings in an Access form or report. For example, the Filter property of a form contains the name of a field in a table. If you then change the name of that field in the table, the AutoCorrect feature does not automatically change the field name in the Filter property of the form.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

Steps to Reproduce the Behavior

1. Open the Northwind sample database.
2. On the Tools menu, click Options.
3. In the Options dialog box, click the General tab. Make sure that the Perform name AutoCorrect check box is selected, and then click OK.
4. On the View menu, point to Database Objects, and then click Forms.
5. Open the Orders form in Design view.
6. In the property sheet for the form, click the All tab.
7. Set the Filter property as follows:

   [CustomerID] = 'BERGS'

8. Scroll down to the OnLoad property, and then click the Build (...) button. In the Choose Builder dialog box, click Code Builder, and then click OK.
9. Type or paste the following code:

   Private Sub Form_Load()
      Me.FilterOn = True
   End Sub
   					

10. On the File menu, click Close and Return to Microsoft Access.
11. On the View menu, click Form View. Note that the form is filtered to display only records for Berglunds snabbkop.
12. Close the form, and when you are prompted to save changes, click Yes.
13. Open the Orders table in Design view, and then change the CustomerID field name to Customer ID by inserting a space between Customer and ID.
14. Close the table and when you are prompted to save changes, click Yes.
15. Open the Orders form in Form view. Note that you are prompted with an "Enter Parameter Value" prompt for CustomerID.