ACC2: Subform's DefaultEditing Can't Be Changed to Allow Edits

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database NWIND.MDB.
2. Create a new form with the Main/Subform Wizard. Base the main form on the Suppliers table and the subform on the Products table.
3. Add text box controls for the Supplier ID, Company Name, Contact Name, and City fields to the Main Form.
4. Add text box controls for the Product ID, Product Name, and Unit Price fields to the subform.
5. Save the subform as myProductsSubform. Save the main form as MySuppliersMainForm.
6. Open the MySuppliersMainForm form in Design view
7. Change the DefaultEditing property to Read Only.
8. Without using the wizard, add a command button to the form.
9. Open the Properties window. Select the OnClick property for the command button, and then click the Build button. In the Choose Builder dialog box, select Macro Builder, create the following macro, and then save it as mcrAllowEdits:
   

          Macro Name      Macro Actions
          -----------------------------
          mcrAllowEdits   SetValue
                          SetValue
   
          mcrAllowEdits Actions
          ----------------------------------------------
          SetValue
            Item: DefaultEditing
            Expression: 2
          SetValue
            Item: MyProductsSubform.Form.DefaultEditing
            Expression: 2
   						

   
   NOTE: The mcrAllowEdits macro will change the DefaultEditing property to Allow Edits (2 in Access Basic).
10. Save the MySuppliersMainForm form, and then open the form in Form view.
11. Try changing one of the entries. Note that you cannot do so because the main form is read-only. Try to change entries in the subform. Note that you cannot do so because the subform has inherited the read-only property from the main form.
12. Click the command button, and try changing some entries on the main form. Note that now you can change them because the DefaultEditing property was changed to Allow Edits. Try to change some entries on the subform. Note that you cannot do so because the subform remained Read Only.

Steps to Work Around Behavior

1. Open the main form in Design view.
2. Change the DefaultEditing property to Allow Edits.
3. In the OnLoad property of the main form, create the following macro, and call it mcrReadOnly. This macro will change the DefaultEditing property to Read Only (3 in Access Basic).
   

         Macro Name     Macro Actions
         ----------------------------
         mcrReadOnly    SetValue
                        SetValue
   
         mcrReadOnly Actions
         ----------------------------------------------
         SetValue
            Item: DefaultEditing
            Expression: 3
         SetValue
            Item: MyProductsSubform.Form.DefaultEditing
            Expression: 3
   						

4. Try changing the entries by repeating steps 11 and 12. Note that this time the form allows edits.