I did something very similar. Essentially you'd want to setup the filter on your new form based off the two criteria you are specifying.
This is the form that opens when you double click on the text box:
Code:
Private Sub Form_Open(Cancel As Integer)
Me.MClmNum = Forms!frmClaimSearch.MClmNum.Text 'Copying the value from your record filter to the new form (MClmNum as an example)
Me.MClmLoanNum = Forms!frmClaimSearch.MClmLoanNum.Text
Forms!frmClaimSearch.MClmNum.Text = "" 'Clearing it if you used a separate text box to identify the record (I did, not sure if it's necessary)
Forms!frmClaimSearch.MClmLoanNum.Text = ""
Dim strMyFilter As String
Dim lngLen As Long
If Not IsNull(Me.MClmNum) Then
strMyFilter = strMyFilter & "([MClmNum] = """ & Me.MClmNum & """) AND "
End If
If Not IsNull(Me.MClmLoanNum) Then
strMyFilter = strMyFilter & "([MClmLoanNum] = """ & Me.MClmLoanNum & """)"
End If
lngLen = Len(strMyFilter)
If lngLen <= 0 Then
strMyFilter = ""
Me.Filter = strMyFilter
Me.FilterOn = True
Exit Sub
Else
strMyFilter = Left$(strMyFilter, lngLen)
Me.Filter = strMyFilter
Me.FilterOn = True
End If
End Sub