Move Focus From Subform To Main Form

[burrina]

DatePaid on subform OrdersPaymentSub set focus on form OrderDetails CustomerID

When user tabs to this final field, on the subform, how can I make it go back to the main form?


Control on subform is named DatePaid , what event should I use and from where?
Control on main form is named CustomerID

1. Main form is named OrderDetails
2. Subform is named OrdersPaymentSub

[June7]

Not something I've done.

Is the subform in Datasheet or Continuous views?

Google: access vba set focus on main form from subform

Here is one idea:
http://stackoverflow.com/questions/1...m-to-main-form

I think this is easier in Single view with Cycle property set to CurrentRecord. Then could try the Exit or LostFocus event of the last control.

[burrina]

Pretty Cool, The F6 key did the trick, Thanks, Here is my code that worked for me.
Select Case KeyCode

Case vbKeyF6
Me.Parent.[CustomerID].SetFocus
DoCmd.GoToControl "CustomerID"
End Select