Tab order in Subform

[COII]

Dear all,

I have a form include two subforms. Tab order will be sorted by :

1. enter all fields in Mainform
2. then shift to "A" Subform to continue enter field
3. Finally, shift to "B" Subform after finish input for "A" Subform

It got a problem on "B" Subform. When I finished input in last field in "B" Subform and press "TAB", it cannot run out to Mainform to create new record.I already checked "TAB ORDER" and there is no problem on it. How can I do for this situation?

Thank you.

 

[lupins46]

You will have to use the OnExit event procedure for the last control on B and use code firstly to set the focus back to A and then set the focus to the required control on A.