Hi guys,
I am working on a simple billing software. I have all my products listed in tblItem with ItemID_PK as primary key & Item description. On a Sales form under SalesDetails I have a combo box where user can choose between items by typing and in ItemID_FK the value is being stored. Now I was wondering how I can make the search being done on Item description to show results even if the text is some where in between of the complete description. Like for example:
Item Description
Polyester semi dull Maharani weft weave
Now Access only searches the above when polyester is typed and the followed by semi and so on. I want it to search on any word or combination of words, like let us say Maharani OR Maharani Weave OR Maharani Semi.
Hope I have been able to explain my question.
Looking forward to your reply.
Thanks and Regards
Deepak Gupta