Tab index multiple subforms

[TToc2u]

I have a parent form with two subforms, one of which contains additional subform.

I would like the user to be able to tab through the whole form. My idea is to set a button as the last tab index on a subform that will set focus (when it recieves focus) to the target subform. Then i will make the button invisable.

Form organization

• Parent Form
  
  • Subform1 <--- buton location
  • subform2
    
    • sub-subform <--- button target

I want to set the focus from subform 1 to sub-subform using button

this is the coding I have in the buttons (on focus) event:


=[Forms]![Parent Form]![Subform2].[Form]![sub-subform].[Form]![sub-subform control].SetFocus

No error... just doesnt do anything.

[RuralGuy]

Moving the focus to SubForms is not real straight forward. It is a two step process. First you need to set the focus to the SubFormControl and then in the next step the control you want on the actual SubForm.

[TToc2u]

What do you mean by a subform control. i know what a textbox control is but I dont see the sam "control source" option under the form tab.

Do you think you can give me some example coding?

[RuralGuy]

A Form is displayed on another Form by means of a SubFormControl. It defaults to being named the same as the SubForm it displays, but it need not be so. This SubFormControl has two special properties on the Data tab of the property sheet: LinkMasterFields and LinkChildFields. Your command button should have an [Event Procedure] in the click event so it will use code. The code will look like:

Forms.MainFormName.SubFormControl2.SetFocus
Forms.MainFormName.SubFormControl2.Form.sub-subformControl.Form.ControlOnsub-subform.SetFocus
...using your names of course.