ACC2: Cannot Add Record After Changing DefaultEditing Property (122673)

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

If you open a form with the form's DefaultEditing property set to Can't Add Records, using Access Basic code from a global module to set the DefaultEditing property to Allow Edits will not cause the form to allow new records to be added.

RESOLUTION

One way to work around this problem is to first set the DefaultEditing property to Data Entry, and then to Allow Edits. The following example demonstrates how to add a command button to a form that will set the DefaultEditing property so that you can add new records.

CAUTION: Following the steps in this example will modify the sample database NWIND.MDB. You may want to back up the NWIND.MDB file, or perform these steps on a copy of the NWIND database.

Start Microsoft Access and open the sample database NWIND.MDB.
Open the Customers form in Design view.
Set the form's DefaultEditing property to Can't Add Records.
Add a command button named Add to the form.

Set the new command button's OnClick property to the following event procedure:

      Sub Add_Click ()
        Me.DefaultEditing = 1   'Sets DefaultEditing to Data Entry
        Me.DefaultEditing = 2   'Sets DefaultEditing to Allow Edits
      End Sub

Save the form, and then close it.
Open the form in Form view. Note that you cannot add new records.
Choose the Add button. Note that you can add new records.

MORE INFORMATION

Steps to Reproduce Problem

Follow steps 1-3 in the "Resolution" section above.
Save the form, close it, and then open it in Form view. Note that you cannot add new records.
Create a new module and then choose Immediate Window from the File menu.
Type the following line in the Immediate window and then press ENTER:

Forms![Customers].DefaultEditing = 2
Select the Customers form. Note that you still cannot add new records.