Form with two subforms

J

JimS

I have a Main Form with two Subforms linked by Parent/Child relationships.
I have installed a command button control on the main form called btnCopy. I
want it to take various fields from the selected row in subform1 and insert a
record into the table underlying subform2. I never need to reference subform2
in this context, but I'm having trouble figuring out the syntax to
referencing subform1's columns...
 
K

Klatuu

You refer to subform objects by using the name of the subform control on you
main form. You do not use the name of the form being used as a subform. You
also have to include the subform control's Form property so Access
understands where you are looking:

Me.MySubFormControl.Form.ControlName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to setup and read data from nested subforms 2
2 Subforms 1
Another Synchornizing Subforms Q 2
Linking two datasheet subforms 1
Form + 2 subforms 2
Using multiple subforms 8
disappearing subform (sorry for cross-posting) 2
linking subform to subform? 3

Top