Tabbing between subforms and main on form page

[Imbriani]

I know this is probably a very simple question, but I can't seem to find an answer in help files of books. Is there a way set the tab order on a form so that users can tab smoothly between controls on the main form and the subforms on the same form page.

Any help is always appreciated.

Kathy

 

[BNPMike]

Fore the last one in tab order you could probably create a macro for the On Exit event that runs SelectObject for the subform. I assume focus would move to the first field in its tab order. I haven't tried this, mind you.

 

[Imbriani]

I was able to do that for the control just above the subform, but once I'm in the subform, I haven't been able to find a way to move to the next subform by using the Tab.

Kathy

 

[aldior]

I use this simple code, I hpe it will work for you.
This changes the focus to the main form every time you click any sub-form tab.

DoCmd.SelectObject acForm, "MymainForm", False
DoCmd.GoToControl "Name"
Forms!Consolidated.Employment.Visible = False
Forms!Consolidated!NewReferallsT.Form.Visible = False
Forms!Consolidated!NarrativeT1.Form.Visible = False
Forms!Consolidated!Referall Rej.Form.Visible = False
Forms!Consolidated!Closings.Form.Visible = True