I assume you are using the BeforeUpdate event on a form to capture this
information.
If you've implemented user level security, you can use the CurrentUser()
function to grab the Access username.
If you haven't used ULS, you can capture their windows login name using the
function at
http://www.mvps.org/access/api/api0008.htm
--
Joan Wild
Microsoft Access MVP
Eleanor of Aquitaine wrote:
[Quoted Text] > Is there a way to track who last modified a record? I have a last
> modified date and time, but I also want to know who performed the
> modification.
|