View Full Version : Date modified


nata4
08-25-2001, 08:14 PM
I'm asked to put a field on the form that'll show the last time this record was accesses. So this date should change each time a user updates ANY field on the form.
How is this done?

Pat Hartman
08-25-2001, 10:48 PM
Add a new column to the table to hold the LastChangeDate information. Then in the BeforeUpdate event of each form that updates this table add the following line of code:

Me.LastChangeDate = Now()

Be sure to lock and disable this field on the form so that it cannot be manually changed.