Last Saved By 1

[Cristodul]

Hello everybody
I'm new user in Access.
I'm trying to create a form and I was wondering if is possible that Microsoft Access to automatically propagate a field called Changed By and in that field to be the File property - Last saved by

Thank you!

 

[JoeAtWork]

No automatic setting, but easy enough to implement if you change data through bound forms.

In the form's After_Update event, add:

   ChangedBy = CurrentUser

That is assuming you have a field called ChangedBy in the table, and you are using a security file (.mdw). If you are identifying your users some other way, replace CurrentUser with whatever is appropriate.

 

[PHV]

Instead of the form's After_Update event I'd put the code in the form's Before_Update event

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886