How do I used wildcard characters in Query by Form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Byron - 31 Mar 2006 05:30 GMT

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!!!!

Reply to this Message

Duane Hookom - 31 Mar 2006 05:43 GMT

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

Signature

Duane Hookom
MS Access MVP
--

> 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
[quoted text clipped - 7 lines]
> P.S. I'm new to Access, but a quick learner.
> Thanks so much!!!!

Reply to this Message