Tabbing into continuous subform ignores the first control

[ernie]

When I tab into the subform, from the last position in the main form, the
focus moves to the second control in the continuous subform except on the
first record entered in a session. I shift+tab back to the first control and
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 the
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 anything.
Is there a way to get the tabbing right?
ern.

 

[Guest]

Did you set the tab order in design view of the subform?

 

[ernie]

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
view
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
Regards,
ern.