Update fields only after changes

  • Thread starter Thread starter Ed Cones
  • Start date Start date
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
 
Put your code in the form's BeforeUpdate event. It only fires if something's
been changed.
 
thanks. I just discovered that F1 still works to find out what those
properties do. Doh!
 
Back
Top