Keeping a history in a table

[Guest]

Before updating a record in a table via a bound form, I want to keep a
history of the entire record before it was updated.

I've tried copying the record using an event procedure on the 'before
update' event of the controls on the form but another copy of the record is
created when I move to the next control and so on.

What I'm looking to do is to capture a 'snapshot' of the record before any
changes are made and then capture an entirely new record once all the updates
for the record are finished.

Is there a way of doing this?

 

[Dirk Goldgar]

Before updating a record in a table via a bound form, I want to keep a
history of the entire record before it was updated.

I've tried copying the record using an event procedure on the 'before
update' event of the controls on the form but another copy of the
record is created when I move to the next control and so on.

What I'm looking to do is to capture a 'snapshot' of the record
before any changes are made and then capture an entirely new record
once all the updates for the record are finished.

Is there a way of doing this?

Have a look at this article of Allen Browne's:

http://allenbrowne.com/AppAudit.html