asked on Create query criteria from a form plus wildcard
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
Like "*science*"
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
[Forms]![Enquiries]![Searc
So what I need is something like
Like "* & [Forms]![Enquiries]![Searc
How can I do that?
What works as criteria is
Like "*science*"
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
[Forms]![Enquiries]![Searc
So what I need is something like
Like "* & [Forms]![Enquiries]![Searc
How can I do that?
Microsoft Access
Last Comment
Fritz Paul
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
But it works fine now.
Don't know what I would have done without you.