Wildcards in input boxes

[maviko]

I have a database that keeps track of all my different tools. I made a query to search the TOOL TYPE field. This query brings up an input box to ask what to search for. In a normal search you can use wildcards (*, ?, &) and search for part of a field. However, the input box will search only for the exact entry. Is there a way to use wildcards with an input box?
TIA

 

[WayneRyan]

Maviko,

In your underlying query:

Exact Match: [SomeField] = "SomeCriteria"

WildCards: [SomeField] Like "*" & "SomeCriteria" & "*"

Like means you have "*", = means no "*".

Wayne

 

[maviko]

Thanks Wayne!