Copy records from Subform A to Subform B

[Jane]

Hello everyone

I have a main form with 2 continuous subforms.

I would like to select a number of records (say 1, 2 or 3 etc) in the 1st
subform and paste them into the 2nd subform.

I can do this with Copy and then Paste Append but I was wondering if this
could be done with VBA.

Something like (on the 1st subform)
Select the records to copy then click a button to copy them.

Then on the 2nd subform another button that says Paste

Is this possible or will be it be very complex.

Thank you

Jane Hollin

 

[Jane]

Sorry I should have said that I only want to copy some of the items on the
1st subform - I don't want to copy the StudentID but only all the other fields

Thank you

 

[John W. Vinson]

Hello everyone

I have a main form with 2 continuous subforms.

I would like to select a number of records (say 1, 2 or 3 etc) in the 1st
subform and paste them into the 2nd subform.

I can do this with Copy and then Paste Append but I was wondering if this
could be done with VBA.

Something like (on the 1st subform)
Select the records to copy then click a button to copy them.

Then on the 2nd subform another button that says Paste

Is this possible or will be it be very complex.

Thank you

Jane Hollin

Data is not stored in forms or in subforms. It's stored in Tables, and only in
Tables!

And it should NOT be stored redundantly in two different tables.

I think you need to stop, and reconsider your table structure! What is it now?
What are the recordsources of these two subforms, and what data are you trying
to copy?