preserving old value before being updated through a form

[jason]

While using MS Access Form, how can i preserve the
original/old value of the text field before being RE-
updated /Edited by any user.

 

[Jeff Boyce]

Jason

One approach might be to use the BeforeUpdate event and write a procedure
that stores the old value elsewhere.

 

[Guest]

But where/how to store the old value ?

 

[Jeff Boyce]

Where do you store the new value? (rhetorical question ... answer: in a
table) If you want to "store" a value, you need a table.