Form with multiple subforms

[Eric F]

I have a "Main Form" (not switchboard) that would have contact information
and would like to have a subform below. What I would like is some hyperlinks
that would change the subform. Clicking on the different links would change
and replace the subform. So I would have numerous subforms that would cycle
through depending on what link the user clicked.

My thoughts are that there needs to be some code that would reference a
table containing all the subforms. Then assign the links a specific number
that would refer to the subform. What I dont know is if there is a way to
replace subforms in a specific area.

Any thoughts would be greatly appreciated

~Eric

 

[PC Datasheet]

Use a tab control and turn the tabs off. Have the same number of pages as
you have subforms. Place a subform on each page. Use an option group to go
to the pages of the tab control.

 

[Marshall Barton]

I have a "Main Form" (not switchboard) that would have contact information
and would like to have a subform below. What I would like is some hyperlinks
that would change the subform. Clicking on the different links would change
and replace the subform. So I would have numerous subforms that would cycle
through depending on what link the user clicked.

My thoughts are that there needs to be some code that would reference a
table containing all the subforms. Then assign the links a specific number
that would refer to the subform. What I dont know is if there is a way to
replace subforms in a specific area.

You could use your table of forms as the RowSource of a
combo box to use for the links. The combo box's After
Update event can then set the subform control's SourceObject
to display the selected form object.