create an audit log with user name and date

[haj]

I'm new but would like to create an audit trail showing who has made changes and the date. I get the date okay but it is the user name causing that is causing me problems. I keep getting "admin". I want the credentials of that I would use on my computer when I log in.

[CJ_London]

try the environ function

environ("username")

[orange]

haj,
You may find this useful.

[alansidman]

Here is another solution you may find valuable.

http://www.datawright.com.au/access_..._in_access.htm