Solved Visible/ Invisible Tab pages (1 Viewer)

tihmir

Registered User.
Local time
Yesterday, 21:09
Joined
May 1, 2018
Messages
257
I made 2 of 3 tab pages (with TabCtl514) invisible when loading the main form (frmInspecion) with the code:
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

Nifty Access Guy
Staff member
Local time
Today, 05:09
Joined
Jul 9, 2003
Messages
16,274
The example "Password Protected Tab" on the Nifty Access website here may be useful to you:-


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

tihmir

Registered User.
Local time
Yesterday, 21:09
Joined
May 1, 2018
Messages
257
The example "Password Protected Tab" on the Nifty Access website here may be useful to you:-


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

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:09
Joined
May 7, 2009
Messages
19,229
see this demo.
see the code on the Load event of the form
and the AfterUpdate event of the combo.
 

Attachments

  • tabVisible.accdb
    428 KB · Views: 554

tihmir

Registered User.
Local time
Yesterday, 21:09
Joined
May 1, 2018
Messages
257
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!
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:09
Joined
May 7, 2009
Messages
19,229
it doesn't matter where the combo is (as long as not in the Subform).
 

Attachments

  • tabVisible.accdb
    512 KB · Views: 519

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:09
Joined
May 7, 2009
Messages
19,229
as Side note, you can Reference the Page directly and not
using it's Parent (TabControl, as in my demo).
 

Users who are viewing this thread

Top Bottom