Solved Visible/ Invisible Tab pages

[tihmir]

I made 2 of 3 tab pages (with TabCtl514) invisible when loading the main form (frmInspecion) with the code:

    Private Sub Form_Load()
        Me.Prescriptions .Visible = False
        Me.Аcts.Visible = False
    End Sub

The first tab page (with form frmPSD and Page Index 0) is always visible. On that form I have combobox (cboInspecion).
So, I need after update that cbo to make rest tab pages to be visible. How is possible to do it?

 

[Uncle Gizmo]

The example "Password Protected Tab" on the Nifty Access website here may be useful to you:-

Tab Controls - Nifty Access

Tab Controls You can use a "Tab Control" to present several pages of related information. A "Tab Control" allows you to squeeze more information on to your Form, making it possible to have a smaller Form, or have a more "information dense" Form. You can also place subforms on your Tabs.See my...

www.niftyaccess.com

Contact me (PM) and I will tell you how you can get a free copy...

 

[tihmir]

The example "Password Protected Tab" on the Nifty Access website here may be useful to you:-

Tab Controls - Nifty Access

Tab Controls You can use a "Tab Control" to present several pages of related information. A "Tab Control" allows you to squeeze more information on to your Form, making it possible to have a smaller Form, or have a more "information dense" Form. You can also place subforms on your Tabs.See my...

www.niftyaccess.com

Contact me (PM) and I will tell you how you can get a free copy...

I sent you a PM

 

[arnelgp]

see this demo.
see the code on the Load event of the form
and the AfterUpdate event of the combo.

 

[tihmir]

see this demo.
see the code on the Load event of the form
and the AfterUpdate event of the combo.

Thank you, Mr arnelgp for your help.
Тhe code works perfectly, but in my case the combobox, that I want to after update is located on the form Which is into Page1
Oh, I just added: Me.Parent.Page2.Visible = .Combo5.ListIndex > -1,
and now the code works perfectly for me! Thanks again, Mr arnelgp for your time. I appreciate it!

 

[arnelgp]

it doesn't matter where the combo is (as long as not in the Subform).

 

[arnelgp]

as Side note, you can Reference the Page directly and not
using it's Parent (TabControl, as in my demo).

 

[tihmir]

as Side note, you can Reference the Page directly and not
using it's Parent (TabControl, as in my demo).

Thanks for the advice and help, arnelgp!