You could easily step through the objects on the form and compare their values to the values in the control source couldn't you? If they are different, then you store the new value in a table. However, using bufferering and getfldstate() as you exit each field would be a better idea I think.
>For an application that I have created my customers are requesting something like an audit trail. Is there an easy way to compare data on a form with the database and to store all modifications into a seperate table.
>
>Any suggestions (or solutions) are welcome.
>
>Regards,
>
>Ron Brahma
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"