I have a form with a Lookup method. I have it set as this:
This will allow the user to search for a record by first or last name. But if they try and search with both it will not return anything. Can someone help me out? I need to to be searchable by first, last, or both.
Thanks.
Code:
SearchStr = FilterSearch & "(tblCalls.CustFirstName LIKE " & "'" & txtSearchBox.Value & "*' OR tblCalls.CustLastName LIKE '" & txtSearchBox.Value & "*')"
This will allow the user to search for a record by first or last name. But if they try and search with both it will not return anything. Can someone help me out? I need to to be searchable by first, last, or both.
Thanks.