Here's what populates my sfPartsList.
Code:
Private Sub txtSearch_KeyUp(KeyCode As Integer, Shift As Integer)
Dim sql, search As String
// replace ' with '' and spaces with *
search = Replace(Replace(txtSearch.Text, "'", "''"), " ", "*")
sql = "SELECT * from PartsList " _
& "WHERE sheet like '*" & search & "*' " _
& "OR vendor like '*" & search & "*' " _
& "OR desc like '*" & search & "*' " _
& "OR cat like '*" & search & "*' " _
& "OR subcat like '*" & search & "*'" _
& "OR partNum like '*" & search & "*' "
Me.sfPartsList.Form.RecordSource = sql
End Sub
So it's updated every keypress to narrow down search results. I might be searching for a 2'x2' something and it may give me several records containing 2'x2', but when I double click on one of those records I want it to add or append that record to another subform. I just can't recall a way to reference the record double clicked on...