multiple criteria search in unbound text box

[ponneri]

Hi.

I have an unbound text box on a form that searches a word in a table and populates a combo box on a form with records related to that word.

But, now I need to search with multiple words for the same.

What I mean is, the table has data in the form of LT or L&T or Larsen & Toubro etc entered which all mean the same.

So, I need to enter LT,L&T,Larsen & Toubro in one text box and then search with the combo box listing all the records with any of these words.

Can someone please help soon ??

 

[Ranman256]

The BETTER way is not to use 1 textbox,
instead, make a table , tFind,
you would add each search term as its own record:
LT
L&T
etc...

The query would join this tFind table to the field in the data table,and run.
BUT

if these words are in the middle of other words (like: 'bob smith of L&T is available')
then this wont quite work either,
The only solution is to use VB to scan the list of words in tFind table and run a fuzzy search on the field.