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