Search box on form

  • Thread starter David Smouts via AccessMonster.com
  • Start date
D

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.
 
S

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.
 
Top