Tagging a new record to a user

  • Thread starter Thread starter Leif
  • Start date Start date
L

Leif

I've added a column to my table with a date type, and set
its default to =Date(), which works fine. However, when
I created a column for the user name, and tried setting
its default to =CurrentUser() I was told it does not
recognize the function.

How to I automatically populate a new record with the
name of the user that created the record?

Thanks,
Leif
 
Put code in the BeforeUpdate event of your form to copy that value into that
field:

me![TheFieldName] = currentuser()

If you are not using forms - the users are enterng directly into the
tables - you will not be able to do it.

HTH,
TC
 
Back
Top