subforms

[PJ]

I have a tab page with two subforms in it. When I tab to the last combo box
in the first subform it does not tab to the first text box of the second
subform. How would I do that? Thanks in advance.

 

[boblarson]

In the Lost Focus event of the last text box on the first subform put:

Me.Parent.YourSecondSubformContainerName.Form.YourFirstTextBoxName.SetFocus

Where YourSecondSubformContainerName is the name of the control on the main
form that houses the second subform (not necessarily the subform name). It
is possible that the container name is the same as the subform name, but it
isn't necessarily so. So you have to use the container name.

And YourFirstTextBoxName is the name of the text box on the second subform
that you want to get the focus.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________