I have a vb.net windows form that uses filters on the on [bindingsource]
I am trying to get a search criteria that is found anywhere in a string to return in the filter results.
[exisiting code] Master_ContactsBindingSource.Filter = "c_company = '" & InStr(CompanySearch.Text, 1) & "'"
The problem is that I receive no results (and does not error either) for terms that I know are in the table such as "son".
The desired result is to return all records that contain the search term "son" but clearly I have this wrong.
c_company = [table field]
[CompanySearch.text] is the textbox with the search term