i am getting a run time error of 2465 when i try to reference a sub form on my main from from an on click event from another sub form on that same form. the subform i am trying to reference is not visible until this on click occurs and should be filtered based on what record is clicked. below is a sample of my coding:
Private Sub number_Click()
If Me!Sub.Visible = True Then
Me!Sub.Form.Visible = False
Else
Me!Sub.Form.Visible = True
Me!Sub.Form.Filter = "[number] =" & Me!number
Me!Sub.Form.FilterOn = True
End If
End Sub
any thoughts?
Private Sub number_Click()
If Me!Sub.Visible = True Then
Me!Sub.Form.Visible = False
Else
Me!Sub.Form.Visible = True
Me!Sub.Form.Filter = "[number] =" & Me!number
Me!Sub.Form.FilterOn = True
End If
End Sub
any thoughts?