You need a field in your table that stores the record to store the date, in the BeforeUpdate event of the form place this code to update the date. I usually call the field updated, so here's the code:
[tt]
'Update time/date record changed to Date()
If Me.Dirty Then
Updated = Date
End If
[/tt]
I myself prefer to put in the date and time:
[tt]
'Update time/date record changed to Now()
If Me.Dirty Then
Updated = Now
End If
[/tt]
The code inspects the form and if a change has been made, updates the field [Updated] to the system date/time. Now just put a field on your form showing the [Updated] field and I would disable it so the users can't modify it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.