Need to save the default/logged user to field in a table

[May2000]

I need to save the default/logged user to a "field" in a table so that I can tract who is changing or adding records. What should I do?

Thanks.

 

[Remou]

You can use:

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

Or:
CurrentUser()
But without Access security, this will return "Admin".

Or:
MsgBox Environ("UserName")
Returns the network login name, depending on your set-up.