I have a table that has a field named "Keywords". In the table are two records so far. In the keyword field one record has "Baseball". The other record has "Football Baseball". Then I am designing a query and the criteria is:
Like "*" & [Forms]![frmSearchByKeyword]![txtKeyword] & "*"
And I have a "Search" form with a field named txtKeyword.
But for some reason when I enter "Baseball" in the text field and run the query I get only the record that has "Football Baseball". The query does not return the record ALSO that has "Baseball".
What is wrong with this?