How do I used wildcard characters in Query by Form?

  • Thread starter Thread starter Guest
  • Start date Start date
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!!!!
 
Set your criteria to something like:
Like [Forms]![formname]![controlname]
or
Like "*" & [Forms]![formname]![controlname] & "*"
 
Back
Top