Keyword Searches

[ddrew]

I have a search form that works really well except the Keyword Search box. The box is an unbound textbox. i want to be able to search by multiple words with maybe a coma seperator. I guess a bit like this forums search field. At present if I have the phrease "This is test data" in my descriptiopn field and put "This is" in the keyword search field it will find it, if I put "this test" it wont find it. I want to find records with all or some of the words in the keyword box

 

[wwwredback]

Hi ddrew,

THis is a sample database uploaded by Thinh that will be perfect for you.

Hope it helps,

Cheers

James.

 

[ddrew]

I probabley didn't explain this very well. The keyword textbox is part of a larger search form with the results appearin in a subform. So that the user can put in as much criteria as he wishes. With keywords, it refers to a memo field , the user could have written anything in it. So when he comes to put words in the keyword search field it could be something like, "data, test, looking. On pressing the search button it will find akll records with all or some of the words