SubForm to Parent

[henryclay]

Is there a way to move from a field in a subform to a field in its parent using code and or a keyboard combination?

I have tried using code for setfocus and the gotocontrol.

I want to be able to save and goto a new record on the parent form when I complete my entries on the subform, without having to use the navigation bar.

[ScottG]

When you tried the Set Focus command what happened? When you are on the subform you have to refer back to the Parent Form in the proper format (Forms![ParentFormName].Command?) to have the code work. Would this following code work?

Forms![ParentFormName].SetFocus
DoCmd.GoToRecord , , acNewRec

Thanks,
ScottG

[henryclay]

When you tried the Set Focus command what happened? When you are on the subform you have to refer back to the Parent Form in the proper format (Forms![ParentFormName].Command?) to have the code work. Would this following code work?

Forms![ParentFormName].SetFocus
DoCmd.GoToRecord , , acNewRec

Thanks,
ScottG

No! I'm having to use the mouse to get the focus back to the parent form. I've tried putting code in the LostFocus property from the last control on the subform, but it doesn't work. If I can get focus to goto the parent form from the subform I know how to get the rest of my code.

Thanks