Hide/Unhide Tab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark S - 04 Dec 2005 18:47 GMT

I am try to hide a Tab control with underlying forms attached. When I click
on a combo box on the main form I want this Tab control to become visible.
When I use the following code I am able to hide/unhide the Tab but not able
to select the actual Tabs.

Any help is appreciated.

Private Sub Combobox_Click()
If [Combobox] Then

Me!TabCtl0.Visible = True

Else

Me!TabCtl0.Visible = False

End If
End Sub

Reply to this Message

Rick Brandt - 04 Dec 2005 18:58 GMT

> I am try to hide a Tab control with underlying forms attached. When I
> click on a combo box on the main form I want this Tab control to
[quoted text clipped - 14 lines]
> End If
> End Sub

What exactly do you mean by "...select the actual Tabs"?

Do you mean that you want to make that page the currently selected page? If so
what code are you using and what is the problem? The code you have above is not
doing anything to affect the current page.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Mark S - 04 Dec 2005 19:33 GMT

Thanks Rick for your reply. I have a Tab control with 4 tabs on a form. Each
tab has a form attached to it that gets data from underlying queries. I want
the form to load with the Tab hidden. When I click on the combo dropdown that
is on the form I wan the Tab to appear with all 4 tabs accessible. This code
provides the ability for the Tab to appear but the different pages on the tab
won't let me move from one to another.

>I am try to hide a Tab control with underlying forms attached. When I click
>on a combo box on the main form I want this Tab control to become visible.
[quoted text clipped - 14 lines]
>End If
>End Sub

Reply to this Message

Rick Brandt - 04 Dec 2005 19:46 GMT

> Thanks Rick for your reply. I have a Tab control with 4 tabs on a
> form. Each tab has a form attached to it that gets data from
[quoted text clipped - 3 lines]
> for the Tab to appear but the different pages on the tab won't let me
> move from one to another.

I don't understand why that would be the case. As long as a TabPage is visible
you should be able to click on it and have that page move to the front. Are you
saying that when you do this nothing happens or do you get an error?

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

George Nicholson - 05 Dec 2005 20:31 GMT

Check to make sure that the Enabled property of each tab/page is not set to
False. It should be True.

HTH,

Signature

George Nicholson

Remove 'Junk' from return address.

> Thanks Rick for your reply. I have a Tab control with 4 tabs on a form.
> Each
[quoted text clipped - 28 lines]
>>End If
>>End Sub

Reply to this Message