ACC: Preventing Users from Adding New Records (95/97)

MORE INFORMATION

You can set the AllowAdditions property under the Data tab of the form's property sheet. The default setting is Yes (True or -1) and allows the user to add new records. If you set this property to No (False or 0), the user cannot add new records. The No setting disables the New Record indicator on the toolbar and the Data Entry command on the Records menu.

The following example demonstrates how the AllowAdditions property works.

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 Customers form in Form Design view.
3. If the property sheet is not displayed, on the View menu, click Properties to display the form's property sheet.
4. In the Form property sheet, click the Data tab and set the AllowAdditions property to No.
5. Add a command button to the Customers form. Set the command button's OnClick property to [Event Procedure], and then click the Build button to the right of the OnClick property box.
6. Type the following statement in the Form_Customers module:
   
   Forms!Customers.AllowAdditions = True
7. Close the Form_Customers module and save the Customers form.
8. Open the Customers form in Form view. Note that Record on the Insert menu and the New Record selector are disabled. You cannot add any records. However, if you click the command button, note that the new record options are enabled.