Need code for record update

  • Thread starter Thread starter Jay Oken
  • Start date Start date
J

Jay Oken

I have two fields:

Date_Last_Updated
Last_Updated_By

How can I get these to update automatically when someone changes a record?
The first field should use the current date and the second field should use
the current user (I have security activated and have a user login list).

Thanks,
Jay
 
In the form's BeforeUpdate event set the values of these two controls. If
the controls are bound to fields in the table, then the fields will be
updated when the record changes are saved.

Example:
txtDate_Last_Updated = Date
or to include time also,
txtDate_Last_Updated = Now

txtLast_Updated_By = CurrentUser
 
Back
Top