Need code for record update

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
 
W

Wayne Morgan

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
 
Top