Recording the date when a record was modified

_Nickel_

Registered User.
Local time
Today, 23:42
Joined
Nov 11, 2003
Messages
31
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 :)
 
I closed access and opened it again and now it works :rolleyes:

It does show the date and the time though. Is it possible to make it only display the date?

Thanks
 
Replace Now() with Date()
 

Users who are viewing this thread

Back
Top Bottom