creating tab order in linked forms

[grierfield]

I create a one to many database – the tab order works fine on the “one” data entry form but when the entry continues in the next linked form – the tab jumps to the last field entered – and does not start at the beginning of that second form which is where I would like it to begin

Using Msaccess 2003

 

[AndyInNC]

So this is a form with a sub-form? Adjusting the tab order of the child form to be the order you need should do the trick.

Or if this a databound form, in the Form_Current event add:
[tt]
Dim ctl As Control
Set ctl = FirstControlInTabOrder
ctl.SetFocus
[/tt]