Tabs on Tabs?

[Guest]

Is it possible to place a tab control onto another tab? I have a main form
with 9 tabs, each containing a subform. I would like to place another set of
tabs onto one of those tabs, and have the second set of tabs contain
subforms. Can I do this?

Thanks,
Tara

 

[Rick Brandt]

Is it possible to place a tab control onto another tab? I have a
main form with 9 tabs, each containing a subform. I would like to
place another set of tabs onto one of those tabs, and have the second
set of tabs contain subforms. Can I do this?

Thanks,
Tara

You either...

Place the second TabControl "in front of" the first and use code in the Change
event of the larger one to hide the smaller one except when a particular page of
the larger one is selected. This creates the illusion of a tab-within-a-tab,
but can be messy to work with while in design view where the secondTabControl is
always visible (and in the way).

OR...

Place a Subform on one page of your current TabControl and place another
TabControl onto the form that is displayed within the subform control. This can
be nasty if you wanted the controls on the nested TabControl to be bound to the
same table as the parent form. Access will see this as two separate users
modifying the record simultaneously.

 

[Guest]

Since each tab on the second set of tabs is its own table and form, I decided
to go with the second option, and so far, it appears to be working. Thank
you so much for your help!

--Tara

 

[Guest]

I'm trying to bound fields to the same table as the parent form. I have 3
tabs on the main tab: 1st tab has a subform with another set of tabs, the 2nd
tab has fields from the parent form followed by another subform and the 3rd
tab has fields only from the parent form. I enter the data in the parent
form and that works fine, but when I try to enter data in the 2nd tab, it
gives me an error warning about 'can't save changes because another user is
changing data at the same time' and tells me can't save record. Any help is
appreciated.