entering a subform in Datasheet view

[ivan]

I have a form (CustomerInfo) that has a subform within it (order). Within
that subform is another subform (OrderDetail). That subform (OrderDetail) is
displayed in Datasheet view.

When I am entering new customers and their respective orders, the first
order entered into the OrderDetail subform is fine with the "tab" field
orders correct. The curser moves into the first field upon entry into that
subform. After entering the detail for the first customers order, we then
go onto a new CustomerInfo record. On this second customers order (and
subsequent customers orders), when I go from the Order form to the subform
"OrderDetail", the curser goes to the wrong field
(not the first field in the tab order), which is the third field in the
datasheet view. I have checked the tab order and it is correct. I have tried
using a DoCmd to send the curser to the correct field but that doesn't seem
to work.

Is this caused by the subform being in Datasheet view or am I doing
something wrong in my DoCmd statement?

 

[ivan]

also... it appears that the curser re-enters the subform on the same field
that it left on. So if I switched to a new customer record and the curser
was in the third field of the subform, that is the field that it re-enters
the subform on when it moves into the new customers orderdetail subform.