Search box on form

  • Thread starter Thread starter David Smouts via AccessMonster.com
  • Start date 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.
 
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.
 
Back
Top