I am using the following Search filter criteria
Like "*" & [Forms]![PriceListForm].[TxtPrc] Or Like [Forms]![PriceListForm].[TxtPrc] & "*"
When I enter word "Broken" in the text box "TxtPrc" I get the following result
Broken Glass Green
Broken Glass Mix
Broken Glass White
for word "Green" in the text box "TxtPrc" I get the following result
Broken Glass Green
for word "Mix" in the text box "TxtPrc" I get the following result
Broken Glass Mix
for word "White" in the text box "TxtPrc" I get the following result
Broken Glass White
But if I type Glass the result is empty.
How can I fix this If I type "Glass" I should get the result wherever word "Green" is, It should be displayed.