Set focus to a subform

[SandyG]

My tab control will not move my cursor from a combo box in
one subform to the next subform even though it is listed
in tab order and has a tab stop and index number. Is
there a way to do this. I tried to set focus for a field
in the new subform but I can't remember the exact syntax
to go from a form to a subform Any help is greatly
appreciated. Thanks SandyG

 

[John Viescas]

Sandy-

Looks like you're having all sorts of focus problems today. <s>

So, you have two subforms, one on each of two tabs? If the subform is the
only control on the tab, then the focus should move to the first control
inside the subform when you click the next tab. Tabs also have a Tab Order.
Go to Design view and click on the tab that's giving you the problems.
Choose Tab Order from the View menu.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)