Hi, I have been successful copying a vba code from one of your posts on how to copy and paste a record by declaring the desired fields that needs to be copied in form's declaration and creating two button "copy" and "paste". Works like magic. My problem is how can I copy multiple records and paste them at the same time. My data entry form has main form that has a Questionlist box of Questions. The second list box on the same form displays subquestions based on the selection made in Question list box. The subform allows to add response for a selected subquestion. Majority of the time response choices are the same for all the subquestion. Based on the scenario below, if I do data entry for SubquestionA, I want to copy/paste all three records to Subquestion B and Subquestion C. Question A has Sub questions A, B, C. SubQuestion A: Response Choice: 1, 2, 3 SubQuestion B: Response Choice: 1, 2, 3 SubQuestion C: Response Choice: 1, 2, 3 Please let me know how can I achieve that. It will save a lot of time entering the same records. Thanks for all your help.