View Full Version : Search a field using a keyword


wrekless
08-09-2000, 07:38 AM
I want to construct an optional keyword search, only if the keyword field is populated.

I want to search in the field CATALOG_DESC.
This is what I have under the field as criteria in the query, it won't work.

IIf([Forms]![Form Shelf Life]![Keyword],"*[Forms]![Form Shelf Life]![keyword]*",[CATALOG_DESC])

The true condition doesn't work.
Basically, I'm trying to say if true set criteria: *keyword*

Help anyone???