I am trying to use a search form and search a form that contains a subform. Some of the searchable field are on the form and some on the subform. The code for the for works fine, but when I try to add code to search the subform it tells me that the form doesn't exist!
Here's what I have in the search form for a subform field:
If Len(Forms!frmfilterforrecord!Field1_RegID & vbNullString) Then
Forms!frmMyMain_Form.sfrmMySubform.Form.Filter = "[Reg ID] = " & Chr$(34) & _ Forms!frmfilterforrecord!Field1_RegID & Chr$(34)