Hi,

I need some advices. I'am trying to design a form to search abstracts with predefined keywords. For example, a keyword likes blue flowers but maybe in the abstract or in the title but blue and flower don't stick together. Is it possible to search words in any where in a field?

Thanks,

Le

Like "*" & [TheWord] & "*"

Like "*" & [TheWord] & "*"
Thanks, right now, I'am using the option filter. The problem is, several words doesn't write the same way, for example sometime the word like "show-up" or "show up".

Here what I wrote :



Me.subfrmAbstractSearch.Form.Filter = "Title like ""*" & _
"show-up" & "*" & "company" & "*""" Or "Title like ""*" & _
"show up" & "*" & "company"
Me.subfrmAbstractSearch.Form.FilterOn = True



The second part after the OR, it seems don't work. It gives me an error message, incompablility type.

So, what should I do?
Thanks,

Le