Form with two subforms



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:


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