Search Field for Subform

[perrymans]

I have a subform to enter details. The user selects an item from a combo box, then enters the value.

How can I create a search, from the main form, that will filter the main form, but is searching the subform info?

Example: I have a form with all computers. The subform contains IP Addresses. I want to search for all computers with IP addresses of 192.168.1.*

Thanks. Sean.

 

[perrymans]

I got it! I did a Google search and found some pretty hard examples. Fortuantely, I found an easy one:

Private Sub cmdSubSearch_Click()
Dim strSQL As String
Dim strSearch As String
If IsNull(Me.txtSubSearch) Then
    ' If the combo is Null, use the whole table as the RecordSource.
    Me.RecordSource = "SelQ_Item"
Else
    strSearch = Me.txtSubSearch
    strSQL = "SELECT DISTINCTROW SelQ_Item.* FROM SelQ_Item " & _
        "INNER JOIN SelQ_ItemDetail ON " & _
        "SelQ_Item.ItemID = SelQ_ItemDetail.ItemID " & _
        "WHERE (((SelQ_ItemDetail.ItemDetailValue) Like '*" & strSearch & "*'));"
    Me.RecordSource = strSQL
End If
End Sub

Just uses an Inner Join. The remove filter button just resets the recordsource back to the original query.

Thanks. Sean.