Search using any words in a feild

  • Thread starter Thread starter Clark
  • Start date Start date
C

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
 
Clark,
Use the wild cards.

*partial text*

will find all records that include the partial text phrase.
 
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
 
Back
Top