Generally you should avoid moving records between tables. It is better to add a field for "archived" that can be used to filter out the records.
If you must, then see if this helps:
How to Duplicate a Main Form and Its Subform Detail Records (Click Here)
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Last edited by HiTechCoach; October 8th, 2013 at 03:01 PM..
|