How to keep track of data changes (best way..)

[Uwe Range]

Hi to all,

I am developing a database where, with time, it proved to be necessary
to keep track of the changes to the data. It is fairly easy to keep
track of the time when a record was changed (afterupdate event)

-> Is there there a smart way of finding out which field has been
changed? I don't want to set a procedure on every field on the edit
form for keeping track of that, because the forms will be changed from
time to time.

Thanks in advance!

Uwe

[Allen Browne]

Use the BeforeUpdate event of the form, not its AfterUpdate event. There is
no point in dirtying the record again immediately after is is saved.

When you use Form_BeforeUpdate, you can also compare the Value of each bound
control to its OldValue, to pick up the differences.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Uwe Range" <ur****@gmx.de> wrote in message
news:64**************************@posting.google.c om...

I am developing a database where, with time, it proved to be necessary
to keep track of the changes to the data. It is fairly easy to keep
track of the time when a record was changed (afterupdate event)

-> Is there there a smart way of finding out which field has been
changed? I don't want to set a procedure on every field on the edit
form for keeping track of that, because the forms will be changed from
time to time.

Thanks in advance!

Uwe

[Bas Cost Budde]

Uwe Range wrote:

Hi to all,

I am developing a database where, with time, it proved to be necessary
to keep track of the changes to the data. It is fairly easy to keep
track of the time when a record was changed (afterupdate event)

-> Is there there a smart way of finding out which field has been
changed? I don't want to set a procedure on every field on the edit
form for keeping track of that, because the forms will be changed from
time to time.

You can loop the Controls collection of a form; every control that has a
controlsource property also has an OldValue property. If that is not
equal to its Value, the control has changed.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea