Update Loging

[Jason]

How can I save the current date and user to two fields
when they make a change to a paticular record. I want to
recored "Last Modified By" and "Last Modified On" for
each update of a record through a Form.

Thanks,
Jason

 

[Larry Stewart]

In the Form_BeforeUpdate event, do the following:

Me.lastModBy = CurrentUser()
Me.LastModOn = Now()

 

[TC]

As long as the OP undertsnads that CurrentUser() will always return "Admin"
unless:

(1) He has created some users in his workgroup file, and

(2)
(a) he has assigned a password to the Admin user, so that everyone must
log-on with a username/password when they open the database; or,
(b) he starts the database using a shortcut including the /user switch to
identify the current user.

HTH,
TC

 

[Andy]

Couold he not use the GetUsername API instead of using CurrentUser?

hth,
Andy

 

[Guest]

True. I assumed he was using an Access Workgroup file.