knuckelhead
Technical User
I have a main form which has a button, noted below, that creates a new blank screen for Main form top section input. it works fine.
Private Sub cmd_ADD_Junction_SHEET_Click()
DoCmd.GoToRecord , , acNewRec
End Sub
But now, i want to ADD a button on the Tab page to create a new record in the SUBFORM.
I am confused because this subform Add button would technically be on the Main form, even though the button resides on the Tab page. right? So how do i get this newer button to add just to the subform. and do nothing to the main form data?
Private Sub cmd_ADD_Junction_SHEET_Click()
DoCmd.GoToRecord , , acNewRec
End Sub
But now, i want to ADD a button on the Tab page to create a new record in the SUBFORM.
I am confused because this subform Add button would technically be on the Main form, even though the button resides on the Tab page. right? So how do i get this newer button to add just to the subform. and do nothing to the main form data?