Hello, How can I place a timestamp when a record is updated. I have Private Sub Form_AfterUpdate()
R Rod Mar 9, 2009 #1 Hello, How can I place a timestamp when a record is updated. I have Private Sub Form_AfterUpdate()
S Stefan Hoffmann Mar 9, 2009 #2 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 <--
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 Mar 9, 2009 #3 AfterUpdate fires after the record has already been updated. Try using BeforeUpdate instead. Carl Rapson
AfterUpdate fires after the record has already been updated. Try using BeforeUpdate instead. Carl Rapson
