Search using any words in a feild

[Clark]

At the moment I have a form which I filter using FIlter By
Form. This only seems to return results however, for
records containing all the words typed into the field(s).

Is there any way I can change this to search for any of
the words being entered?

Regards

 

[Fredg]

Clark,
Use the wild cards.

*partial text*

will find all records that include the partial text phrase.

 

[Larry R Harrison Jr]

It may be more complicated than you can deal with, but
depending on that I have just come up with code which will
do a "boolean" search. That is, if an entry
contains "Posada Del Rio Apartments" then entering "Posada
Apartments" (notice the words don't go in the same order)
will pull it up.

I haven't yet posted it to my website, email me at
(e-mail address removed) if you want more information.

LRH