R rap43 Jun 16, 2009 #1 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
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 Jun 16, 2009 #2 Private Sub cmdSave_Click () DoCmd.RunCommand acCmdSaveRecord Me.Parent!SomeControl.SetFocus DoCmd.GoToRecord acDataForm, "frmYourMainForm", acNewRec End Sub
Private Sub cmdSave_Click () DoCmd.RunCommand acCmdSaveRecord Me.Parent!SomeControl.SetFocus DoCmd.GoToRecord acDataForm, "frmYourMainForm", acNewRec End Sub