Like criteria

[spcscooter via AccessMonster.com]

Is there a way to use criteria that will allow the user to enter part of a
field and have everything that has that text show up in a query. I tried Like
*[enter problem code]* but all of the records were returned. So basically I
want the user to type 710 in field that has 710 DVR Dead in one field.

 

[ghetto_banjo]

Like "*" & [Enter Problem Code] & "*"


that should do the trick.

 

[spcscooter via AccessMonster.com]

You arey hero!

Like "*" & [Enter Problem Code] & "*"

that should do the trick.

 

[spcscooter via AccessMonster.com]

You are my hero!