So I have a search on a split-form which works fine. The only issue I have with it is it will only search in the exact format the text is entered in the text box. So if I search for John Jones it will search for John Jones, or if I search for Iowa John Jones it will search for that, but if it was entered as say 'John Jones Iowa' it will not find it because the Iowa is out of order. Is there a way to have the search field search for each word in the text box anywhere in the field and only display those records which have all of the words entered, just anywhere not in any specific order?
Code below is a single field which includes person name, company name, services offered, and location. So if I was searching for a chiropractor in Iowa I could type 'Iowa Chiropractor' and it would show them all, or 'Iowa Chiropractor Jones' if I knew the providers name was Jones.
Code:
[ProviderSearch] Like "*" & [Forms]![frmProviderSearch]![ProviderSearchFieldTxt] & "*"