Have an audit trail/log in Access 2010 but also need to prompt a user to confirm changes before Save

[MelT]

I've built an audit trail table to track changes to a form. Is it possible for me to add code to also ask a user to confirm any changes they make to a record? Where would I place the code?



Here is the code I currently have in place for my form and the Event Procedures Before Update and After Del Confirm.

Option Compare Database
Option Explicit

Private Sub cmdQuit_Click()
DoCmd.Quit
End Sub

Private Sub Form_AfterDelConfirm(Status As Integer)
If Status = acDeleteOK Then Call AuditChanges("ID", "DELETE")
End Sub

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then
Call AuditChanges("ID", "NEW")
Else
Call AuditChanges("ID", "EDIT")
End If
End Sub

[orange]

You may get more info from Allen Browne's audit material
Since you are using Acc2010, you may find this Data Macro info useful.

Also, you mention changes to a form, but it is really using Form events to audit changes to data in tables, right?

[MelT]

Yes, my table of customers is connected to a form. If someone edits the customers record in that form the audit table tracks those changes.