Trouble with 'Like' expressions as query criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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]|"
 
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?
 
* 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] & "*"
 
Back
Top