gotocontro on Main Form from Field in Submfor

[TinaCa]

The user wants to exit a field in the subform and go back to the combo box on the main form to select a different record. (PS the main form is inside the navigation form). I can get it to work outside of the navigation form but not inside it. I have tried using the following code in both a macro and vba and access can't find the field in the main form.

DoCmd.GoToControl Forms![frmNavigation]![NavigationSubform].Form![Combo12]



Thanks

[ketbdnetbp]

I haven't worked with navigation forms before, so this is just a guess. However, it may be worth a try.

In VBA, I would try...

DoCmd.gotocontrol "Combo12"

or,

DoCmd.gotocontrol "NavigationSubform"
DoCmd.gotocontrol "combo12"

and, see if that gets any desirable results.

All the best,

Jim