How navigate from subform to main form using tab or enter

[Kaykayme]

I know this is an age-old question but I have a bit of a different twist. I
created a wizard using tab control. There are several subforms on the pages
of the tab control. This form does not have any data tables bound to it. It
is mainly used for calculation and to produce an Estimate sheet in Excel.
The only data tables used are in the combo boxes. So none of the subforms
have master-child links. The users requested for ease of navigation to be
able to use the tab key or enter key to go from subfom to the main form
control that advances the wizard forward and backward. I have tried using
the OnExit event on the last control on the subform but have been
unsuccessful. This only allows navigation to the main form but not a
specific control. Any suggestions?

 

[John W. Vinson]

I know this is an age-old question but I have a bit of a different twist. I
created a wizard using tab control. There are several subforms on the pages
of the tab control. This form does not have any data tables bound to it. It
is mainly used for calculation and to produce an Estimate sheet in Excel.
The only data tables used are in the combo boxes. So none of the subforms
have master-child links. The users requested for ease of navigation to be
able to use the tab key or enter key to go from subfom to the main form
control that advances the wizard forward and backward. I have tried using
the OnExit event on the last control on the subform but have been
unsuccessful. This only allows navigation to the main form but not a
specific control. Any suggestions?

One trick you can try is to put a small textbox on the form - make it one
pixel square and transparent so the user can't click into it. Put it last in
the tab order, and in its GotFocus event set the focus to the desired control
on the mainform. This may require two steps:

Me.Parent.SetFocus
Me.Parent.controlname.SetFocus