complex tab control

[bfence]

I have about 8 subforms that I'm trying to connect in different tabs.
The main form is my Characteristics table which links to Candidacy by
ID#. Then, in another tab I'd like to put Teaching Site which should
connect back to the Candidacy ID#. Is that possible? I've pulling my
hair out trying to get this to work!

Thanks!
Betsy

 

[Golfinray]

Yes. There is a tab control on your form toolbar. Each time you click it, you
will get two new tabs. You can arrange and name those tabs as you desire.
Remember that the tabs are "holsters", the form goes in the holster. So, you
add each form to a tab. Allow the form wizard to do that for you if possible,
linking each to the main form. Also remember that each "holster" has
properties and each form has properties and if you want changes, you have to
set each.

 

[Ron2006]

Using either the wizard or manually entering them, load the
appropriate linking field names into the parent/master/child controls
of the subforms.

If the main form is not bound to a table you will have to do this
entry by hand - the wizard will refuse to run.

Ron

 

[bfence]

First create your main form then add a tab control. Add addidtional pages to
your tab control so you have eight pages. Create each of your subforms
separately. Open your main form in design view and add a subform control to
each tab page. At each page, select the subform control and set the source
object property, linkMaster property and LinkChild property appropriately.
These properties are all on the Data tab of properties.

Steve

Thanks for all the great feedback. I don't think explained what I'm
trying to do correctly. The Characteristics table and the Candidacy
Table are linked on the Characteristics ID. All of the other subforms
need to link to the Candidacy ID on the Candidacy Table. There's no
way to link between tabs is there?