I apologize if this has been aswered elsewhere. I've looked, but haven't found any clear answer on this. I'm also very new to VBA, and I don't really know what I'm doing.
I have the following setup:
Form
-Record1
--data1
--data2
--data3
--Subform1
---recordA
---recordB
I need to copy data1, data3 and Subform1 from Record1 and enter it into a new record, Record2, which also has a subform, Subform2. I've figured out how to copy data1 and data3, but I don't know how to copy Subform1. Alternatively, I could copy recordA and recordB from Subform1 and enter those into Subform2, but I don't know how to do that either. It seems like it should be similar to copying data1 and data2, but the answer is eluding me. Any help would be much appreciated.