Form with two subforms

  • Thread starter Thread starter JimS
  • Start date Start date
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...
 
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 always get the top level form reference, when calling from any subform/subform... 0
How to setup and read data from nested subforms 2
Subform 1
2 Subforms 1
requerying a subform 1
disappearing subform (sorry for cross-posting) 2
linking subform to subform? 3
Referring to a control on another form 5

Back
Top