I want to create query criteria which is the combination of a wildcard * and contents of a control on a form.
What works as criteria is
which results in all titles with science somewhere in the title.
Now I want to enter the word science or any other word in a control on a form and write the criteria to give the same result. The reference to the control is
So what I need is something like
Like "* & [Forms]![Enquiries]![SearchQualTitles] & *"
How can I do that?