How can you set tabs between subforms so they will tab to next for

I have created a form and added 4 subforms to it. How can you get the tabs
from one form to land in the next form without clicking the next form to
activate it?

Hope I'm explaining myself well?

Thanks
Don

On Sun, 8 Nov 2009 18:36:04 -0800, blanch2010
wrote:

I have created a form and added 4 subforms to it. How can you get the tabs
from one form to land in the next form without clicking the next form to
activate it?

Hope I'm explaining myself well?

Thanks
Don

One way to do this is to put an extra unbound textbox on the first subform. It
must be enabled and visible, but you can put it behind another control, and/or
set its size to one twip square so the user can't click into it
unintentionally. Put it last in the Tab order and set its GotFocus event to

Private Sub txtRelay_GotFocus()
Parent!secondsubform.SetFocus
Parent!secondsubform.controlname.SetFocus
End Sub
--

John W. Vinson [MVP]