tab from subform to subform

[papa jonah]

I have two subforms each with two comboboxes. The two subforms are on
a common main form. Is there a way to add code (maybe to the got focus
event) that will allow tabing from the second combobox of one subform
to the first combobox of the next subform?

TIA

 

[Guest]

Here's one way, most likely the long way, but it might work:
In Design View of the main form, via the View menu, and the Tab Order
option, make sure the the second subform's control is subsequent to the first.
Then in Design View of each subform, set the Tab Stop property of each
control on the each subform to "No", with exception to the two comboboxes, of
course. Pressing Tab, while the first subform has the focus, should take you
from the first subform's combobox to the second's, and Shift-Tab should
return you to the first's.
Good luck.
Trent