Tabbing out of subforms

[Guest]

Older versions of Access required you to ctrl+Tab out of subforms when
jumping from a subform back to the main form.

Later versions 2000? Seem to allow you to do it automatically with a simple
tab.

Is there a setting for this? I have some subforms that I have disguised as
regular text fields. (By inserting a subform in "single form view" sizing the
form almost as small as the textbox itself, and of course, hiding navigation
etc.) I'd like the user to tab in and out of these fields unbeknownst that a
subform is being used.... For some reason, it expects a ctrl+tab.

Can I change this setting, or is there a programatic way to mimic this?

 

[Al Camp]

jonefer,
Try placing one more field (out of site) on your subform with a TabOrder
so that when you hit Tab while in the displayed subform field, you'll Enter
that "dummy" field. Now the OnEnter event of the dummy field could be used
to navigate to your main form.
hth
Al Camp

 

[Dale Fye]

Like Al said, but I'd just use the lost focus event of the contol that
should preceed your "subform" to set the focus to the control on your
subform, then use the lost focus event of the subforms control to set the
focus on the next control in the sequence.

HTH
Dale