Auto Date or Now for field

  • Thread starter Thread starter DEVOURU
  • Start date Start date
D

DEVOURU

I'm trying but, I cannot get a field to place =Date() or =Now() when it has
focus. This is updating an existing record, not new. D'oh!

-JS
 
I'm trying but, I cannot get a field to place =Date() or =Now() when it has
focus. This is updating an existing record, not new. D'oh!

-JS
Click to expand...

How are you setting focus to the field? If you want to timestamp a
record when any field on the record is updated, you should consider
using the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel as Integer)
<any validation code here>
<if validation is successful>
Me!txtTimestamp = Now()
End Sub
 
Back
Top