Having trouble with this issue. I'm using code borrowed from somewhere else. I want the code to be independent of the from I am originating the event from.
The original code was driven by an event on a main form. My issue is how to get the code to recognize the name of the subform.
I get an error from the frm variable. It stores the name of the main form.
The original code was driven by an event on a main form. My issue is how to get the code to recognize the name of the subform.
I get an error from the frm variable. It stores the name of the main form.
Code:
Private Sub Title_NotInList(NewData As String, Response As Integer)
Dim frm As String
Dim ctl As String
frm = Screen.ActiveForm.Name
ctl = Screen.ActiveControl.Name
Response = EnterNewTitle(NewData, frm, ctl)
End Sub