Time/User Stamp for Changed Record

[dweekley]

Hello,

looking for some assistance with getting the info for the user when a record is changed

Using an event in Before Update on the form

Private Sub Form_BeforeUpdate(Cancel As Integer)
'Information for who changed record

Me.CTS = Now()
Me.CTSUser = Environ("UserName")

End Sub

However I am getting a compile error 'Method or Data Not Found' with the Me.CTSUer and not for Me.CTS

[JoeM]

Are the "CTS" and "CTSUser" fields placed anywhere on your Form? If not, then they wouldn't be part of the "Me" collection.
Note, if you do not want users seeing/editing those fields, you can add them to the Form, but make it so those fields are not Visible (or lock them).

[dweekley]

ugh...thank you much. That was it.

David