Make Tabcontrol Visible Help...... please

B

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
 
D

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.
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top