I had this question after viewing Environ("USERNAME")
I want to store username and date/Time stamp in each record, for 3 tables.
I am using below same codes for three forms ( BeforUpdate Event)
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!updateBy = Environ("username")
Me!updateTime = Now()
However, in one form, the [updateBy] field and [updateTime] fields are saved, but in two forms its not saved.
Its shows error as Field updateby is not found..
What can be the cause ?
Would appreciate help.
Thanks in advance.