Entry Timestamp

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

Hello,

How can I place a timestamp when a record is updated. I have

Private Sub Form_AfterUpdate()
 
hi Rod,
Private Sub Form_AfterUpdate()
'Create entry timestamp
Me.Entered= Date
End Sub

but when I look at the table there is no data in Entered. Any ideas?
Click to expand...
It's the wrong event as the record is already saved. Use the Before
Update event of the form.


mfG
--> stefan <--
 
AfterUpdate fires after the record has already been updated. Try using
BeforeUpdate instead.

Carl Rapson
 
Back
Top