I can not open a second subform from a first subform using
Public Sub OpenScheduleDetails(passedJobID As Variant)
Dim JID As String
JID = passedJobID
DoCmd.OpenForm "forms![frmMS]![frmControlDispatch]", , , "JobID = " & JID
End Sub
Where the parent form is frmMS and the subform I wish to open is frmControlDispatch. The above procedure is called from a double click event in a second subform on frmms
Keep getting error as forms![frmMS]![frmControlDispatch]
is misspelled or doesnt' exist
Public Sub OpenScheduleDetails(passedJobID As Variant)
Dim JID As String
JID = passedJobID
DoCmd.OpenForm "forms![frmMS]![frmControlDispatch]", , , "JobID = " & JID
End Sub
Where the parent form is frmMS and the subform I wish to open is frmControlDispatch. The above procedure is called from a double click event in a second subform on frmms
Keep getting error as forms![frmMS]![frmControlDispatch]
is misspelled or doesnt' exist