Date Record Amended

[Betsvigi9]

Does anyone know how I can automatically change the date/time in a field to todays date each time it is amended. i.e. so that it shows the last date that the record was amended.

Thanks

 

[JerryDennison]

You can do this at the form level but not the table level. The version of Access you have will determine the best way to handle this. For A97 use the following: In the BeforeUpdate event property of the form use the following(substitute your controlname for the placeholder given):

...
If Me.Dirty Then
Me.DateFieldControlName = Now()
End If
...

For A2k use: In the On Dirty property of the form use the following:

...
Me.DateFieldControlName = Now()
...