Tab off subform to main form

[BonnieW via AccessMonster.com]

I would like to be able to have my users tab off a control in a subform to
another control in the main form. I know I've seen code on here to check for
tab keypress, and on that event kick them back to the main form, but I can't
seem to dig it up again. I've also seen some people suggest a teensy tiny
textbox on the subform whose only purpose is to kick the user back to the
main form. I'm happy with either solution- but is one "better" than another?
If neither are optimal, is there another solution out there for this?

 

[Marshall Barton]

I would like to be able to have my users tab off a control in a subform to
another control in the main form. I know I've seen code on here to check for
tab keypress, and on that event kick them back to the main form, but I can't
seem to dig it up again. I've also seen some people suggest a teensy tiny
textbox on the subform whose only purpose is to kick the user back to the
main form. I'm happy with either solution- but is one "better" than another?
If neither are optimal, is there another solution out there for this?

The simplest(?) solution is to train users to use Ctrl+Tab

Users being users, I have also used the tiny text box with
code like this in its GotFocus event:
Parent.somecontrol.SetFocus