date of change with user name

[aftershokk]

I am using Access as an interface with a SQL database. Currently, when a user changes a particuler field I use an event to update the date of last change on the form. I would like to add user name also. I have not been able to figure this out. HELP!

thanks,

 

[dcx693]

You can use the CurrentUser() function to return the name of the currently logged on user - if you're using Access security. You can also get the Windows logon ID name of the person using Environ("username").

 

[aftershokk]

help

can you pull use name and date time at the same time?

 

[aftershokk]

thanks

All of your suggestions worked very good!