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...
 
Ad

Advertisements

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

Top