[AccessD] Recording field changes

Hi David

You can create a RecordsetClone when entering the current record.
After an update of the record, loop through the fields and compare the
updated record with the clone - when a difference is met, write to the
log.
As you can read the data type of a field you should be able to use a
generic function to compare the two fields.

/gustav

> I have a client that needs to record all changes to the data on a field by
> field basis (they don't want to record whole records if there is a change - 
> just the fields that changed (old and new values)).  My initial though is 
> to put code in every field that records the value on entry, compares this 
> on exit and records the change if they values are different.

> Because there are several hundred fields involved I was wondering if there 
> was any easy way of doing the job without adding code to every field.