Record of last modifying person

[Daryl Au]

How can the database record and show the login-name that last modifies a record

For example, if "Daryl" is the last one modifying a record, there is a field showing on the form that "Daryl" is the last person modifying the record

Thank you so much

 

[Cheryl Fischer]

If you have implemented Access Security on your database, you can use the
following in the Control Source of your form's textbox:

=CurrentUser

Otherwise, copy the code found at:

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

into a module and use the following in the Control Source of your form's
textbox:

=fOSUserName()


hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

How can the database record and show the login-name that last modifies a record?

For example, if "Daryl" is the last one modifying a record, there is a

field showing on the form that "Daryl" is the last person modifying the
record.