AllowDeletions Property

Applies To

Form.

Description

You can use the AllowDeletions property to specify whether a user can delete a record using a form.

Setting

The AllowDeletions property uses the following settings.

Setting Description Visual Basic
Yes (Default) The user can delete records. True (-1)
No The user can’t delete records. False (0)


You can set the AllowDeletions property in the form’s property sheet, a macro, or using Visual Basic.

Remarks

You can set this property to No to allow users to view and edit existing records but not to delete them. When AllowDeletions is set to Yes, records may be deleted so long as existing referential integrity rules are not violated.

If you want to prevent changes to existing records (make a form read-only), set the AllowAdditions, AllowDeletions, and AllowEdits properties to No. You can also make records read-only by setting the RecordsetType property to Snapshot.

When AllowDeletions is set to No, the Delete Record command on the Edit menu is not available.

See Also

AllowAdditions Property, AllowEdits Property, DataEntry Property, RecordsetType Property.

Example

See the AllowAdditions property example.