I am trying to develop an Access database that can search a keywords field from a form. The form simply asks the user to enter a keyword for their topic, and if the keyword entered corresponds exactly with the keyword field the record will be displayed. The problem is that the keyword field may have up to ten keywords in it so I only want it to match part of the field. The current criteria reads
[Forms]![Keywords]![Keyword_entry]
If I try
Like "*[Forms]![Keywords]![Keyword_entry]*" it will not work at all! but if I enter the keywords separately eg: Like "*report*" then it does work. Please help me. I am so close but I can't find anyone who has come across this problem before.

try this:

Like "*" & [Forms]![Keywords]![Keyword_entry] & "*"

That should work.