Tab order issue

[Rada]

I have a form with a subform, the tab order goes through the main form then the fields in the subform, with the last tab going to the next record. My problem is when I have tabbed to the next record/page in the form the last field in the subform is still selected which screws up the tab order in the new record, because when my tab order gets to the subform it goes straight to the still selected field instead of the first field in the subform, I need the tab to take me to the start of the subform on every record like it does on the first record. Really need help with this!

[June7]

That doesn't happen to me. My subform is in Datasheet view and on a Tab control. Tabbing through record returns to the first field of next record.

[Rada]

I mean when I change the main form record, the last field in the subform is still selected so when I tab down to the subform it goes straight to that field instead of the first field in the subform
this is when i tab down to the subform in the first record: and this is what happens in the next record:

[June7]

Understand now and see same.

Sorry, can't find any way to return focus to first control of subform.

[Rada]

damn, I really need a solution to this, I was told to fix this issue for an assignment which I have to submit in the next few hours.

[June7]

I tried code in events of the subform and the subform container control. Nothing worked.