Defualt enter user on data entry screen

[michael]

Hi. I have a table with a control that's a time stamp so I
can keep track of when a record is added. I'd also like to
create a field to track who made the entry. I think I need
to set the default value to =CurrentUser or something. Any
thoughts? THANKS!

 

[Douglas J. Steele]

I don't believe you can set the default value of a table field to the
CurrentUser function. You can, however, set the default value of a form
textbox to it, and, since you should never be updating a table directly,
that should suffice.

Of course, CurrentUser only works if you've turned on Access security (it
returns Admin for all users otherwise). If you want their network ID, check
the code in http://www.mvps.org/access/api/api0008.htm at "The Access Web".