Search field in any where in a field

[le888]

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

 

[Mile-O]

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

 

[le888]

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