navigation question

[nevje]

i have a form that is order/ordersubform:-

orderform
ordernumber
orderdate
ordertype

ordersubform
productcode
productdescription
quantity

the tab order is fine and it starts at order number and goes through
each one as expected and from the main form onto the subform. but when i
goto next record (on the main form as i have hidden the subforms next
record buttons) to create a new order the cursor starts at the beginning
of the subform instead of the main form.

how can i correct this?

 

[Rick B]

in the "ON CURRENT" event of the form, simply add code to set the focus to
the desired field.

Something like...


Private Sub Form_Current()
OrderNumber.SetFocus
End Sub


Rick "B


i have a form that is order/ordersubform:-

orderform
ordernumber
orderdate
ordertype

ordersubform
productcode
productdescription
quantity

the tab order is fine and it starts at order number and goes through
each one as expected and from the main form onto the subform. but when i
goto next record (on the main form as i have hidden the subforms next
record buttons) to create a new order the cursor starts at the beginning
of the subform instead of the main form.

how can i correct this?