Entry Timestamp

R

Rod

Hello,

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

Private Sub Form_AfterUpdate()
 
S

Stefan Hoffmann

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 <--
 
C

Carl Rapson

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
Can you decipher this timestamp? 4
How get earliest timestamp? 3
Update syntax error? 2
Dynamic Naming of Form Button 3
Freezing after update. 3
TxtBox with Timestamp on each change 6
lock records after update query 1

Top