ACC2000: Form with AllowAdditions Set to No Allows New Records

ID: Q208521

The information in this article applies to:

Microsoft Access 2000

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you open a form that has the AllowAdditions property set to No, the form allows you to add records.

CAUSE

The form is being opened programmatically by the OpenForm action with the Data Mode argument in the macro set to Edit. If you're using Visual Basic, the Data Mode argument is set to acFormEdit, A_EDIT or acEdit.

RESOLUTION

Omit the Data Mode argument setting so that Microsoft Access uses the property settings defined by the form.

MORE INFORMATION

When the Data Mode argument of the OpenForm action is set, Microsoft Access overrides a number of form property settings. If the Data Mode argument of the OpenForm action is set to Edit, Microsoft Access opens the form using the following property settings:


   AllowEdits: Yes
   AllowDeletions: Yes
   AllowAdditions: Yes
   DataEntry: No

Microsoft Access uses the default form property settings if you omit the Data Mode argument in the OpenForm macro action.

This behavior is likely to occur when you have a macro that opens a form, because the Data Mode argument is set to Edit by default.

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.

Open the Customers form in Design view and set the AllowAdditions property to No. Save, and then close the form.

Create a new macro with the following action:


   Macro Action
   -----------------------
   OpenForm
      Form Name: Customers
      View: Form
      Filter Name:
      Where Condition:
      Data Mode: Edit
      Window Mode: Normal

NOTE: The Data Mode argument is Edit by default.

Save the macro with a unique name, and then run the macro by clicking Run on the Run menu. Note that the Customers form opens but allows you to add new records.

Close the Customers form and delete Edit from the Data Mode argument of the OpenForm action. Save and rerun the macro by clicking Run on the Run menu. Note that the Customer form opens but does not allow you to add new records.

REFERENCES

For more information about the OpenForm action, click Microsoft Access Help on the Help menu, type "openform action" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: prb

Keywords : kbdta FmsProp
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb