So I am interested in knowing who created the record and who changed it.
I followed the examples from one of the website but I can't seem to get it work.
I have added the below fields to my table and query:
CreateBy Text
CreateDate DateTime Default value =Now()
ModBy Text
ModDate DateTime
and I added the codes to the current and before update events of the form
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
ModBy = Environ("username")
ModDate = Now()
End Sub
Code:
Private Sub Form_Current()
If Me.NewRecord Then
CreateBy = Environ("username")
End If
End Sub
This is what was stated in the examples but it is not working.
Any idea anyone?
Thanks!