Two Questions about Subforms and Tab Controls/Pages

[zashaikh]

I have a Tab Control with 3 tabs that display three different subforms. When I switch between tabs, I want to SetFocus to a specific field in the active subform page. How do I do this? Additionally, is there a way to set a shortcut key (Ex: Crtl + 1) to navigate to a particular tab?

[ranman256]

me.Subform1.form.txtBox.setfocus

use the BUILDER, it always gets the path correct.

[June7]

Set TabOrder property and when form first opens, control with 0 will get focus

Do you really want to force user to be in a particular control when they return to a page? What if they would rather be in the same control they moved to?

This is surprisingly harder than would think. The Tab control pages have events, such as Click, but they don't seem to trigger.

A & in a caption property will cause following character to act as Alt+character shortcut. However, does not work so well on Tab control. Once inside a subform, the main form shortcuts will not work.

[zashaikh]

me.Subform1.form.txtBox.setfocus

use the BUILDER, it always gets the path correct.

What EventProperty should this go under?

[zashaikh]

Set TabOrder property and when form first opens, control with 0 will get focus

Do you really want to force user to be in a particular control when they return to a page? What if they would rather be in the same control they were already in?

A & in a caption property will cause following character to act as Alt+character shortcut. However, does not work so well on Tab control. Once inside a subform, the main form shortcuts will not work.

I am not concerned with TabOrder. I just want to be able to view whatever tab I am interested in by pressing a shortcut-key

And I am positive I want to force the user to be in a particular control.

And I know how that & in the caption allows for an Alt+Character shortcut. But I was hoping for a VBA alternative, so that I can create a new record AND force setfocus.

[June7]

Could use the Tab control Click event. The Tab control Value is the index of the page that is clicked. However, must click on the tab button, not just anywhere on the page.

Select Case Me.Tab1
Case 0
…

Or maybe use the subform container Enter event.

By TabOrder, I meant the property of controls, not the order of tabs. This determines order controls get focus when tabbing or entering.

[zashaikh]

Could use the Tab control Click event. The Tab control Value is the index of the page that is clicked. However, must click on the tab button, not just anywhere on the page.

Select Case Me.Tab1
Case 0
…

Or maybe use the subform container Enter event.

By TabOrder, I meant the property of controls, not the order of tabs. This determines order controls get focus when tabbing or entering.

Thank you June7. The TabOrder thing worked.