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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

After Update Save 1
Freezing after update. 3
Update syntax error? 2
How get earliest timestamp? 3
Writing a General Date from separate date and time fields 3
Can you decipher this timestamp? 4
Will lowest autonumber always be first added? 2
recording changes 12

Back
Top