tab out from subform

[Serguei Makacharipov]

I have a set of controls and subform in subform. I couldn't find the way to
make this subform in subform tabbed out.
it takes the focus and no playing with properties did help to force it to
move focus out.
Will apreciate any advice.
Thank in advance.
Serguei Makacharipov

 

[Ken Snell]

Put a tiny textbox in the subform (height and width both 0). Make this
textbox the last control in the tab order. In the OnGotFocus event for the
textbox, put this code:

Private Sub txtBoxName_GotFocus()
Forms!MainFormName!ControlOnMainForm.SetFocus
End Sub

 

[Serguei Makacharipov]

Cool!
And not expensive!
Thank you very much!
Serguei Makacharipov

 

[Ken Snell]

You're welcome.