Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Access 97-Archiving records to a separate table then edit.

Hello All. I'm having an issue and I've tried thinking of all the workarounds and haven't come up with a usable method.

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.
[535 byte] By [cervantes008] at [2007-11-11 8:49:05]