Access VBA - Prevent records from being deleted in a form that has a subform

Hi

In Microsoft Access forms how do I prevent record deletion. The form that I want to do this has a subform embedded in it.
The form is bound to my "Invoices" table and the subform is bound to my "Invoice Details" table
Should I use a VBA code event?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
PatHartmanCommented:
If you don't want to delete the record if it has invoice details, you can control that with a relationship on the tables.  In the relationship window, draw the join line and in the dialog specify - Enforce Referential Integrity but do NOT specify Cascade Delete.  Without Cascade Delete, Access will not allow the invoice record to be deleted if it has details associated with it but it will allow the invoice to be deleted if it has no detail records.

You can control this on the form by specifying AllowDeletes = No on the Data tab of the property sheet.

The best way to prevent ANY deletes is to use a Data Macro if you are using ACE for the BE or a Trigger if you are using SQL Server.
1
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.