Registering user, who made changes to a record

[Mike]

I have a table with field "Created_by" where Access saves
the name of user who created the record. It is done via a
hidden text box on a form with the default
value "=CurrentUser()".
But I also want to make a field for saving the name of
user who made the last change to a record. How is it
possible to program a form to keep the user's name when
saving changes to an existing record?

 

[Rick Brandt]

I have a table with field "Created_by" where Access saves
the name of user who created the record. It is done via a
hidden text box on a form with the default
value "=CurrentUser()".
But I also want to make a field for saving the name of
user who made the last change to a record. How is it
possible to program a form to keep the user's name when
saving changes to an existing record?

If all data entry is done with forms (which it absolutely should be) then
you use the Form's BeforeUpdate event to set the field to the current user
value.

Me!Revised_By = CurrentUser()