KEYword search from a form field

[Al77]

I am struggling to find the way that you can tell Access to search for a 'like' word (e.g. a 'part' of a string) from the words as input in a Form field.



My queries run perfectly from the form for EXACT matches but I have NO idea how to reference the field for a 'LIKE' search in order to use it for KEYword searches.

My query entry at present = [Forms]![frm_LIBRARY_Dashboard].[Keyword], where Keyword is my form button.

With a 'Like' criteria I can obviously specify the word to search for, but would like to COMBINE both this and the button function using an entry field in the same form.

I hope this makes sense!

Any help / advice much appreciated.

[June7]

Use LIKE and wildcard with text data.

LIKE "*" & [Forms]![frm_LIBRARY_Dashboard].[textboxname] & "*"

[Al77]

FANTASTIC - I had tried so many permutations, but that one did not even occur to me.

THANK YOU!