Update fields only after changes

[Ed Cones]

I'd like to update a date field with the current date and a user field with
an environment variable (USERNAME) only if a change is made to a record. If
the user opens the record and closes with no changes, I don't want to update
the fields. Can someone point me in the right direction. thx

 

[Douglas J. Steele]

Put your code in the form's BeforeUpdate event. It only fires if something's
been changed.

 

[Ed Cones]

thanks. I just discovered that F1 still works to find out what those
properties do. Doh!