Track employee who made changes to record.

[FormerJarHead]

Hi all,



Is there a way to track the changes made to a record? I have added a timestamp field to my form that indicates when the record was changed but I would also like to know which of my staff has made the change. Is this possible and if so can you help with any code that I may need to use. I found this on line but I'm having no luck with it working:
CODE:
Private Sub Form_BeforeUpdate(Cancel As Integer)
' Log the user details to the table
Me!UpdatedBy = CurrentUser()
Me!TimeStamp = Now()
End Sub


What this gives me in the Updated By control is "Admin" instead of the users name.

What do I need to do to fix this?

Thank you

[pbaldy]

CurrentUser() only works with Access Security. You can use this:

http://access.mvps.org/access/api/api0008.htm

[FormerJarHead]

CurrentUser() only works with Access Security. You can use this:

http://access.mvps.org/access/api/api0008.htm

Should I put this in the Before Update =[fOSUserName]

[pbaldy]

Following your earlier code:

Me!UpdatedBy = fOSUserName()

I typically grab it when the program starts and hold it somewhere (variable or form control) for later use, so I don't have to keep calling the function. Minor thing though.

[FormerJarHead]

Perfect!!!