Trouble with 'Like' expressions as query criteria

G

G-Dev

Anyone have any trouble with 'Like' expressions as query criteria after
converting from '97 to '03 ???? Here is a smple Like expression that is not
working in '03 :
Like "|[forms]![frmtest]![txtTest]|"
 
K

Ken Snell [MVP]

What does "not working" mean? You get no results? You get the wrong results?
you get all the results?

What type of data are in the txtTest textbox?
 
V

Van T. Dinh

* You should always use Wildcards if you use Like.

* The syntax is wrong and I am not sure what the 2 vertical bars are for.

* Try:

Like "*" & [forms]![frmtest]![txtTest] & "*"
 
Top