I want to record the date when a record was modified. I did a search on the forums and found this thread. Now I did just as described and put this into the Before Event property of the form (DateChanged is the field that will hold the date):
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.DateChanged = Now()
End Sub
But it doesn't work.
Please tell me what I did wrong.
Thanks
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.DateChanged = Now()
End Sub
But it doesn't work.

Please tell me what I did wrong.
Thanks
