How do I used wildcard characters in Query by Form?

G

Guest

I'm trying to prompt criteria from a form (Query by Form) and I need to be
able to use wildcard characters. How do I do it? example: "demolition" or
any other input.
I need: "*demo*".
I am currently using [Forms]![formname]![controlname] in my query and a Text
Box on my form to enter the criteria for the query. Do I need to add an
expression in the query or build a macro?

P.S. I'm new to Access, but a quick learner.
Thanks so much!!!!
 
D

Duane Hookom

Set your criteria to something like:
Like [Forms]![formname]![controlname]
or
Like "*" & [Forms]![formname]![controlname] & "*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top