Search box on form

[David Smouts via AccessMonster.com]

Hello,

I need a search box on my form that works like this:

When I search "US" it gives me the result below:

Name Alias City Country
-----------------------------
Jack Ja NY US
US int UI PAR FR
Ursula US PAR FR
Test Te GUS UR

It needs to search in different fields with wildcards.

Is this possible?

Thanks.

 

[Steve Schapel]

David,

If you are using the query design view, put the equivalent of...
Like "*" & [Forms]![YourForm]![YourTextbox] & "*"
.... into the criteria of the query design grid, on a different row of
the grid for each of the fields it applies to.

 

[David Smouts via AccessMonster.com]

Thanks Steve,

This was what I was looking for.

David