Tab off subform to main form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BonnieW - 09 Jul 2007 17:04 GMT

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?

Reply to this Message

Marshall Barton - 09 Jul 2007 20:38 GMT

>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
[quoted text clipped - 3 lines]
>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

Signature

Marsh
MVP [MS Access]

Reply to this Message