Insert a new AutoNumber field, and mark it as Primary Key. The field name audID is suggested. Repeat steps 1 to 6 for any other tables you wish to audit. You are now ready to enter 6 lines of code for your form. From the View menu, choose Code.
Access opens the form in Design View, and displays thecode window.
As Boolean Select the form. In the form's properties, locate OnDelete under the Event tab. Access opens the code window. In the form's properties, locate AfterDelConfirm. Locate the form's BeforeUpdate property.