Return changed fields Access97 bound form

[DannyTmoov2]

Is there any way to catch all of the fields on a databound form (access97) that have changed so i can store:

the field
original value
new value

in a history table?

Any suggestions on this much appreciated,

Dan

 

[RoyVidar]

Changed since what ;-)

Prepare for some work - but fortunately someone has alredy done much - have a look at MichaelRed's faq faq181-291, if I understand you correct, that might be of interest.

Roy-Vidar

 

[PHV]

Do a keyword search in the access fora for audit trail

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DannyTmoov2]

Audit Trail" that was the term i was trying to think of!

cheers guys will check it out