Why doesn't my WILDCARD work?

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

Guest

OK, if I use -
LIKE "*name*"
it works fine. But when I link to a form -
LIKE "*forms![]![]*"
it doesn't work.

Your help is appreciated.

Mike D.
 
Are you trying to get it to use the value of a field on a form? If so, the
syntax should look more like:

LIKE "*" & Forms![frmName]![frmField] & "*"

Access won't evaluate any expression that are inside the quotation marks.

HTH,

Marshall Smith
Project Developers, Inc.
 
THAT'S IT!! Thank you for your help!

Mike D.

-----Original Message-----
Are you trying to get it to use the value of a field on a form? If so, the
syntax should look more like:

LIKE "*" & Forms![frmName]![frmField] & "*"

Access won't evaluate any expression that are inside the quotation marks.

HTH,

Marshall Smith
Project Developers, Inc.


OK, if I use -
LIKE "*name*"
it works fine. But when I link to a form -
LIKE "*forms![]![]*"
it doesn't work.

Your help is appreciated.

Mike D.
Click to expand...


.
Click to expand...
 
Back
Top