Focus within Tabctl

[enilc]

My main form has several subforms. It also has a tabctl set of 5 tabs, each with multiple subforms.



When a use selects one of the tabs in the tbctl, the focus is jumping to a recently added subform, near the bottom and they have to scroll back up to the top of the tabctl. I've been messing with all of the 'tab index' properties, and they seem correct. I have the topmost subform set to tab index 0, and the other subforms in order going down the tabctl. Within each subform, the 'tab index' order is set as well, but each subform has a new tab index order.

I am trying to have the focus set to the topmost control in the topmost subform when the user selects this tab in the tabctl.

Am I off-base using 'tab index' to make this happen? Should I somehow be doing this programmatically via the onclick property of the tabctl?

I appreciate any advice.

Steve

[ranman256]

yes, tab index is the order the cursor lands/travels
but I would suggest to only have 1 subform. Then when user clicks the tab ,swap out the source of the subform.
This saves LOTS of memory. I've had memory errors with > 1 subform.

Private Sub TabCtl_Change()
      
Select Case TabCtl.Value
   Case 0
      subFrm.RowSource = "fPaymentsSub"
   Case 1
      subFrm.RowSource = "fPurchasesSub"
   Case 2
      subFrm.RowSource = "fInventorySub"
End Select
End Sub

[enilc]

Thanks for the response. I'll take a look at using the case statement to resolve.
To more explicitly state the problem:

There is a client form that has several subforms. It also has a tabctl.
The tabctl has 5 tabs: general, retirement, education, estate, investment
Each of those tabs has 3-5 subforms.
On the 'retirement' tab is a 'goals' subform, an 'actions' subform, and a 'retirement spending' subform
When the 'retirement' tab is clicked, the cursor jumps to the 'retirement spending' subform, control tabindex 0
I want focus to be in the 'goals' subform, control tabindex 0.
Each of the subforms (goals, actions, spending) have tabindex order set to 0,1,2.
So, in my mind, selecting the 'Retirement' tab should set focus to subform tabindex 0, control tabindex 0. But it doesn't. It goes to subform tabindex 2, control tabindex 0.

That is the issue I'm trying to resolve. Trying to setfocus to subform 0, control 0 when the tabctl is selected.

I'm going to take a stab at using a version of the code you provided.

[ranman256]

you can tell it to go directly to the object:
forms!masterform.subform.form.txtBox1.setfocus

[davegri]

See if this will work for you. Make sure you are setting properties for the Subform/Subreport control, NOT the subform itself.



And for the others