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

    Kaur
    Expand Collapse
    Guest

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


Share This Page