Now function on change

  • Thread starter Thread starter BrowDa
  • Start date Start date
B

BrowDa

I am trying to create a field in which the date time will change when I edit
any field in the form. I can't figure out how to do it even though it is
probably quite easy. Can anyone help me?


Thanks in advance for any help.
 
I am trying to create a field in which the date time will change when I edit
any field in the form. I can't figure out how to do it even though it is
probably quite easy. Can anyone help me?


Thanks in advance for any help.
Click to expand...

Put code in the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel as Integer)
<do any form validation first>
Me!txtWhenUpdated = Now
End Sub
 
Back
Top