ACC: No "Can't Add Records" Data Mode Argument for OpenForm (95/97) (131585)

RESOLUTION

To work around this behavior, use Visual Basic code to pass a True or False value in the OpenArgs argument of the OpenForm action to set the AllowAdditions property in the form's Load event.

The following example demonstrates how you can use the OpenForm macro action's OpenArgs argument to pass the specified AllowAdditions setting for use in a form.

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

1. Open the sample database Northwind.mdb.
2. Open the Employees form in Design view.
3. Type the following code for the form's Load event:
   

         Private Sub Form_Load (Cancel As Integer)
            Me.AllowAdditions = Me.OpenArgs
         End Sub
   						

4. Save, and then close the form.
5. Open the Utility Functions module in Design view and on the View menu, click Debug Window.
6. Type the following statement in the Debug window, and then press ENTER:
   

   DoCmd.OpenForm "Employees",,,,,,False

   
   Note that the Employees form opens. You cannot add records, but all the employee records are available.