Looking for the best way to 'copy' data from one table to another. So here's the situation... I have four tabs on a form each tab page has a subform. Each subform has identical fields linking to different tables with identical structure. Often times users will check the appropriate 'checkboxes' on the subform for quarter 1. Then when they enter quarter 2 i would like to offer the ability to 'copy' over the data checked in quarter one so they can simply 'add' the checks on the new quarter without having to re-check all the previously check boxes in Quarter one if status remains the same which it normally does. I'd like to offer them a button to click to 'clone' the data check in quarter 1. What's the best way to do this?