Solved Visible/ Invisible Tab pages (1 Viewer)

tihmir

Registered User.
Local time
Today, 15:52
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?
 
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...
 
see this demo.
see the code on the Load event of the form
and the AfterUpdate event of the combo.
 

Attachments

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:
it doesn't matter where the combo is (as long as not in the Subform).
 

Attachments

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

Back
Top Bottom