insert username as default field

[mike]

Hi. I'd like to add a field to a table that will
automatically add the user's name to a field so that I can
keep track of who entered the new data. Any suggestions
would be great! Thanks!!

 

[Duane Hookom]

Do all data entry/editing in forms where you can set the default to a
function that returns the user's name. You can also run event code in the
before update event.

 

[Mike]

Duane, thanks. How would the function look?

-----Original Message-----
Do all data entry/editing in forms where you can set the default to a
function that returns the user's name. You can also run event code in the
before update event.

--
Duane Hookom
MS Access MVP





.

 

[Douglas J. Steele]

Assuming you mean their Windows ID, check
http://www.mvps.org/access/api/api0008.htm at "The Access Web".

If, on the other hand, you've applied Access security, and you want their
Access ID, use CurrentUser()