I have a form and when someone makes a change I have it log the changes to 2 specific fields. The problem, currently, is that it logs these 2 fields regardless if they were changed or somethings else was.
I have this run on the 'BeforeUpdate' event for the form. I know I could put this on these fields only but what I really want is for this to log any and all changes made to any field if possible.
Code:
Me.LastEditedBy = (GetUserName & " on " & Date & " at " & Time() & ". Last Action set to " & Me.LA & " with Action Date of " & Me.DA & "." & vbCrLf & vbCrLf & Me.LastEditedBy)