[AccessD] Recording field changes

Thanks everyone for your replies.  I will be able to start digesting them 
all next week.

-----Original Message-----
>From: David Emerson [mailto:davide at dalyn.co.nz]
>Sent: Monday, June 21, 2004 3:44 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Recording field changes
>
>
>Group,
>
>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.

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (04) 478-7456
Mobile 027-280-9348