No, I thought the order would be the same as the table so I put the controls
in the same order as that. I did look at tab order setting in the Design
of the subform, it is correct.
I seem to have an explanation for the behaviour:
I have been returning to the next record in the main form after entering
the last on the subform by Ctl+Tab which seems to leave the"subform focus"
in the second control. If I tab to the next record in the subform before
Ctl+Tab it leaves the focus in the first control and tabbing back into the
subform acts as expected except in one respect:
This first control on the subform is a combo box with a dropdown expression
in the "On got focus" event.
This expression gets executed when I return to the main form so the combo
box is dropped down until the focus moves into a combo box on the main form
(which has the same expression and therefore drops down). When the focus
tabs into the subform the expression is ignored on the first record,
subsequent visitations cause the dropdown as expected. I may need a
different event to get the wanted behaviour.
Sorry for the unnecessary post and thank you
"Klatuu" <Klatuu@discussions.microsoft.com> wrote in message
> Did you set the tab order in design view of the subform?
> Dave Hargis, Microsoft Access MVP
> "ernie" wrote:
> > When I tab into the subform, from the last position in the main form,
> > focus moves to the second control in the continuous subform except on
> > first record entered in a session. I shift+tab back to the first control
> > the tabbing is normal from then on until the next record gets to the
> > subform.
> > The order of the controls on the subform is the same as the fields in
> > underlying table and the effect is the same in Datasheet view (of the
> > subform).
> > This first control on the subform is a combo box if that effects
> > Is there a way to get the tabbing right?
> > ern.