navigating from a subform to the main form

[Supicek]

Hi

I have a continuos form with a subform placed in the footer of the form. The
subform is also a continuos form.

The intended behavior is:
------------------------------------
after leaving the last field on the subform row, the cursor should return
back to the main form, back on the record where were cursor before jumping to
the subform. Let say I put cursor to the third record on the main form and
jump to the subform, after updating last field in the subform record I expect
the cursor gets back to the 3rd record on the main form

Current behavior is:
--------------------------
cursor gets back to the main form but always to the first record of the
main form.
last field in the subform has on lostFocus evernt :
Me.Parent.orderNumber.SetFocus

does anyone has idea how to resolve this?

thanks
Supicek

 

[Supicek]

I found out that when I put the same command into a Key Press event, it
behavies exactly as I expected. I suspect the problem was, that when I used
LostFocus event Access already fogot the reference to the parent form