Microsoft Access: Record when database records are edited

Platform:Microsoft Access
Task:Record when database records are edited
Discussion:
It's good auditing to record when database records are last changed and by who. Here is a method you can attach to a form's BeforeUpdate event to do so.
Example:
Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me.RecordUpdatedBy = Environ("UserName")
    Me.RecordUpdatedDate = Now()
End Sub
Back to Index