Make Tabcontrol Visible Help...... please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top