Archiving ideas

  • Thread starter Thread starter gecho808
  • Start date Start date
G

gecho808

ust looking for ideas about archiving updates to a record.

Current idea is to keep track of all the controls (text boxes, combo
boxes) that were updated by comparing them with their original values.
Then store only the old (or new) values in the archive table. Now, I know
that there's an onUpdate or Dirty property, but I wanted to take care of
instances when the user changes the record, changes their mind, and hits
eESC or enters the original value. I have a feeling I'm making this
harder than it has to be.

As for comparing the new and old values, I was thinking of using an array.
Any thoughts?

Thanks,
gecho
 
You may use the .Tag on the control to store the original DB value. That
way, you don't habr to think about where it is. It is always the
theControl.tag.
 
Back
Top