How do I autoupdate a date on a form when a record changes?

[DM021]

How do I update a date in a text field automatically whenever a record is
changed?

 

[Allen Browne]

Use the BeforeUpdate event procedure of the form, e.g.:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[MyDateField] = Now()
End Sub