Moving to a specific tabbed page/subform

[DeanO]

I have a new problem I have a Form with three tabs. I want the third tab to open auto when a text box on the first tabbed subform is updated. I have tried the SetFocus event but this will not work, as the subform is not already open. In conjunction with this I have a Select Case statement that auto selects a form to fill this subform I just want the this subform to open if one of the select case form is selected in stead of having click on the tab.

[missinglinq]

I have split this post off from the 3 month old, unrelated thread you posted it in! In the future please start a new thread when you have a new problem/question.

You also never bothered to respond to my post on your previous thread nor give any indication as to whether you had resolved you problem. Forum etiquette, here and elsewhere, requires that you acknowledge responses to your threads and post how you resolved your problem, even if you did so on your own, so that other visitors to your thread may be enlightened.

Linq ;0)>

Moderator

[DeanO]

That was rude of me and I do not use this much to post just to read. Lots of info to be had.
However, if possible I would still like some help with my problem. I

[rsmccli]

I have a new problem I have a Form with three tabs. I want the third tab to open auto when a text box on the first tabbed subform is updated. I have tried the SetFocus event but this will not work, as the subform is not already open. In conjunction with this I have a Select Case statement that auto selects a form to fill this subform I just want the this subform to open if one of the select case form is selected in stead of having click on the tab.

I don't know about your tabbed subform not being open. I think you can just use this to have the third tab come into focus:

Private Sub txt1_AfterUpdate()

Forms.Mainform.TabCtl = 2
'other code

End If