Record of last modifying person

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


Daryl Au said:
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
Click to expand...
field showing on the form that "Daryl" is the last person modifying the
record.
 
Back
Top