Database archive or history

[Michael]

Here is my problem, I designed a database that has mupitle
users, I have a subform that has 22 fields of data.
Problem is that when someone goes in an updates a field,
like the Date, the old one is over written. I would like
to have it to where when new data is enter into the same
record that the old data is saved into and archive or
history table to future reference or reports. Can any
body tell me how to address this problem and fix it?

 

[Cheval]

1) Huh? Have you set the subform to be readonly or
something?
2) Yeah, in the GotFocus event for every field copy the
data to the tag property. Then in the AfterUpdate event
copy the whole record checking the field tags propertied
for changes to the archive table.

 

[Guest]

Copy using VB? I am new to the vb part of access. I am
however going to take a class on it son, but need to get a
jump start on this.

thanks for your help

 

[John Nurick]

Hi Michael,

Take a look at http://members.iinet.net.au/~allenbrowne/AppAudit.html,
which shows how to make your application store an "audit trail" of
changes.