Is there a way to create a field which automatically updates and identifies
the user who last updated a given field?

You need to get the Windows username or use the CurrentUser function (if you
have implemented workgroup security for the database).  See

http://www.mvps.org/access/api/api0008.htm

or refer to help for CurrentUser function.

Show quoteHide quote

Create the LastUpdate field in your table
In the form where you actually perform the update, put in the AfterUpdate
event:

If you have Windows Security:
LastUpdate = CurrentUser

If you do not have Windows Security:
http://www.mvps.org/access/api/api0008.htm

Mauricio Silva 2005

Show quoteHide quote

Don't you mean to use the BeforeUpdate event?  You would want to save the
editing user's ID with the other changes made to the record.



Show quoteHide quote

You are right, it should be BeforeUpdate.

However, eeryone seem to be missing the point, that the OP wants to
record the user last updated "a given field" - his words. It's not
clear what he means by that. Does he mean, the user who last updated:

- /any/ field in that record?

- a /certain, single/ field in that record (eg. Invoice Amount)?

- or does he want a record of who last updated /every/ field? (eg.
Invoice Amount: Tom; Invoice Date: Mark, & so on)

TC

Restrict use of Access to one computer
Splitting a secure database
Prompting for password
MS ACESS cannot open this file error (new uer)
General Question
How do I get back into a database as the administrator once I hav.
Users and Groups list empty
How do I remove user level security?
How do I change Access ownership from <unknown>?
Application Property