Make Tabcontrol Visible Help...... please

[Bob M]

I have a mainform (FrmIssues) with a combo box that when a selection is made
in the box I need the appropriate tabcontrol page to become visible. Since I
many different subforms attahced to my main table the tabcontrol has become
confusing to the user. I was guided to the visible function by others but I
am unsure how to make work properly. FrmIssues is my main form the
tabcontrol currently only has a couple of pages that are not being reworked.
The tabcontrol has on the first page FrmOrdering subform, second page
FrmServicecall subform and on the third page FrmConsumables subform. I have
matching selections in the combo box (i.e. Ordering, Consumables,
Servicecall). I would like to put as much of this as possible in VBA code.
I thank you in advance for your time and efforts.

Regards,

Bob M

 

[Dennis]

You want the tabs all INvisible until a selection is made? And then make the
SINGLE appropriate tab visible?

If so, in the FORM OPEN event:

Me.PageX.Visible = False
Me.PageY.Visible = False
Me.PageZ.Visible = False

Then, depending on your own logic, just set one of them visible, at whatever
point in your code that you want to.

 

[Bob M]

Dennis,

Thanks for your quick response and support. It is very much appreciated!
Worked as advertised! Now I feel a little silly asking the question when it
appeared to be so easy

Many Thanks Again,

Bob M