What is the best way?

[Joan]

I am trying to create an order entry program from scratch. I have built a
form and it does all the calculations. Now I am trying to allow for changes
but still keeping the original data. What is the best way to do this? I
have tried opening another form and a subform but with little success. How
can I keep the original and the changes? Thanks

 

[Allen Browne]

So whenever an existing record is edited (or even deleted?), you want to
make a copy of the record in a history table?

See:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[Joan]

So whenever an existing record is edited (or even deleted?), you want to
make a copy of the record in a history table?

See:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[Joan]

Thank you so much for your help. I will read the article and go from there.
I really appreciate it.