Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Copy/paste Multiple Records

Discussion in 'Information Technology' started by Kaur, Jul 28, 2006.

  1. Kaur

    Expand Collapse

    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
    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.
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page