I have a cont form that has 2 columns that I need to search. I have the following code as the on change (works great on other forms), but the difference here is the client column is displaying results from a query and not data in the table. The bound column of client in the jobstax table is the PK of the client table, so I need the query to show the actual client name on the CF. How do I get the code to search the query results. I am newer to VBA. I can't seem to find a vid from here that addresses that specific issue.

Private Sub SearchBox_Change()
     Me.RecordSource = "SELECT * FROM jobstax " & _
        "WHERE " & _
            "[Client] LIKE ""*" & SearchBox.Text & "*"" OR " & _
            "[Job Name] LIKE ""*" & SearchBox.Text & "*"""    
    SearchBox.SetFocus
    SearchBox.SelStart = Len(SearchBox.Text)
End Sub