Tagging a new record to a user

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
 
T

TC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Confusion over where user templates are stored in Word 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Synchronization problems while moving folders to new email 1
How to default CurUser() into a field in a new record in a Select 5
Need help modifying code 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top