Move to Main Form from Sub

R

rap43

I have form with sub form when I click save on the sub form I need to go to a
new record on the main form. Can someone help.

Thanks
 
B

Beetle

Private Sub cmdSave_Click ()

DoCmd.RunCommand acCmdSaveRecord
Me.Parent!SomeControl.SetFocus
DoCmd.GoToRecord acDataForm, "frmYourMainForm", acNewRec

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sub form opens before the main form in MS Access 0
Main and Sub Forms repost 2
edit button for main and subform 1
Access Passing data from a form to another form! 0
Access Form Refresh 1
Forms PLEASE HELP 9
refresh method in the main form and sub form 2
Forms 2

Top