Thanks for the responses. I wrote code that on click copied the data from the cell into the paste cells and then the paste button copied the data from there to the new place. Works great. Example follows://Click event on Copy buttonvar shot = ShotDesc_subform.SimpleForm.GeneralInfo.ShtTextField1.raw...

Need: I would like to have a button within a subform that allows you to copy all the data (many fields) and then paste it into an empty copy of the subform. Of course the info pasted would fill in all the fields etc.Reason: We routinely need to move subform data from page 3 in the document to page 1...