Access 97-Archiving records to a separate table then edit.
I built a form that pulls info from a Pipeline table. I wanted to archive previous info onto a separate table and keep track of all the people that make edits.
Is there a way to copy the original info (before edits) and paste it into an archive table by way of a click() and then allow the others to make edits after securing the original info? This has been bugging me all week.

