Update fields only after changes

E

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
 
D

Douglas J. Steele

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

Ed Cones

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