Now function on change

[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.

 

[John W. Vinson]

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.

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