Last Updated By Field in Access

[abprules]

Is there a way that I can create a "Last Updated by" field in MS
Access. I know how to do the Date Last Updated but can't seem to find
out how to record the user who last updated the info.

Thanks in advance.

[pietlinden]

abprules wrote:

Is there a way that I can create a "Last Updated by" field in MS
Access. I know how to do the Date Last Updated but can't seem to find
out how to record the user who last updated the info.

Thanks in advance.

if you implement security so that each user has his own userid, you can
use
application.CurrentUser

if not, you can grab the user's domain login name.
http://www.mvps.org/access/api/api0008.htm

but then you're counting on each user logging into the network using
his own username/password. Just set the value in the BeforeUpdate
property of the form.

Otherwise, check Allen Browne's site. he has code that does all this.
www.allenbrowne.com

[ManningFan]

Environ("UserName")

Set your LastUpdatedBy field equal to that value.

abprules wrote:

Is there a way that I can create a "Last Updated by" field in MS
Access. I know how to do the Date Last Updated but can't seem to find
out how to record the user who last updated the info.

Thanks in advance.