tabbing from a subform to main form

[cbearden]

everytime i try to tab from my subform, it creates a new record for that subform. Also, about the subform, the control that links the main form and sub form is unique.
I have now set my Cycle property on my subforms and forms to Current Record. How can I tab from the subform to the main form and vice versa?

Thanks!

 

[RuralGuy]

One way is to put code in the LostFocus event of the last control on the Main/Sub form to set the focus to the Child/Parent form.

http://www.mvps.org/access/forms/frm0031.htm
Forms: Refer to Form and Subform properties and controls