Date modified

[nata4]

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]

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.