Hide/Unhide Tabs 1

[wayniac42]

I require something very similar. I have a database built on 4 tabs, but inside one of those tabs I would like another group of tabs. The problem is that my second group of tabs are being displayed on ALL of the main 4 tabs and not the single tab that I would like it to. What I am asking is if anyone knows of a code that would only make my second group of tabs visible when only 1 of the 4 main tabs is clicked, and when the other 3 main tabs are clicked, the second group of tabs are NOT visible.

Here is a more visual look at the database.

http://www.geocities.com/database4242/database3.JPG

Thank you

 

[PHV]

Does the Education Tab have its own subform ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[VBAPrincess]

You probably won't like my suggestion, but the only way I've been able to get anything like this to work is to hide the tabs (set the property Style=None) and create my own buttons that display the tab pages. Then I have control over what is visible and what is not.

See a simple example here:
hidden tabs

Once I used a set of six radio buttons to determine which tab page to set focus on when the tabs were hidden.

Sorry I didn't have the exact result you were looking for!
Good luck!


Diana
VBA Princess
-- I'm hoping to grow up to be a Goddess!

 

[MajP]

http://office.microsoft.com/en-us/access/HA012300491033.aspx

Read the part of nesting a tab control within a tab control. Basically it is what PHV is suggesting. You can only do this using a subform, but it shows an example.

 

[TheAceMan1]

How are ya wayniac42 . . .

A tab control can't be installed on a page of a parent tab control. This is why your receiving the effect you've stated. However it can be hidden as you seek. in the On Change event of the parent tab control:

[blue]   If Me![purple][b]Parent[/b][/purple]TabCtlName = PageNumber Then
      Me![purple][b]Child[/b][/purple]TabCtlName.Visible = False
   Else
      Me![purple][b]Child[/b][/purple]TabCtlName.Visible = True
   End If[/blue]

Note: [purple]the child tab control can't have the focus when you set visible to false.[/purple]
Although I prefer the method presented by [blue]MajP[/blue] & [blue]PHV[/blue], the above should do just fine . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[wayniac42]

Thank you, it works excellent now You all sure do know your stuff.