Thanks Jeremy... but its not the order displayed thats the problem.. it's
that the curser moves into the third field displayed upon entering the
subform ...instead of the first field. The first time around its ok (1st
customer)... the curser moves to the first field in the subform
(item_number) and then we enter the necessary detail into the remaining
columns. But then when we move to a new customer record, enter the main
customer info and then enter the subform for the order detail (this is now
the second customers order detail) the curser goes to the third column
(quantity) instead of the first column (item number). The fields are
displayed in the correct order... but the curser goes to the wrong field.
And doCmd. doesnt seem to work. It's almost as if the entering of the 1st
customers detail record is somehow influencing the entry point of the curser
for the second detail record.
"Jeremy Wallace" <cd**@abcdatawo rks.SKIPTHISPAR T.com> wrote in message
news:uQ******** ************@sp eakeasy.net...
In a subform in datasheet view, the tab order is ignored. You will move
through the fields in the order in which they're displayed on screen. You
can drag and drop the fields so that they're in the order you want. But
after you do this, make sure to hit ctrl-s, so that you save that order.
Jeremy
--
=============== ==
Jeremy Wallace
AlphaBet City Dataworks
ABCDataworks dot com
"ivan" <in**@achieva.u s> wrote in message
news:TM******** **********@news 4.srv.hcvlny.cv .net... I have a form (CustomerImfo) 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 customers and their
respective orders, the first order entered is fine with the "tab" field
orders correct. On the second and subsequent orders, when I go from the
Order form to the subform "OrderDetai l", the curser goes to the wrong
field (not the first field in the tab order). 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 doesnt seem to work.
Is this caused by the subform being in Datasheet view or am I doing
something wrong in my DoCmd statement?