Ok, let me explain this:
Table Name: MAJORCODEtbl
Field 0: MAJORCODE (Text)
Field 1: MAJORCODENAME (Memo)
Form Name: ACCTCODEfrm
Object Textbox: SEARCHtb - just a textbox the user types in (the only thing the user interacts with
Object Listbox: MAJORCODElb - a listbox whose RowSource is a query - from above table - showing both fields
example
Code:
MajorCode | MAJOR CODE NAME
7096000 | Control Piping, Valves, Hoses
7097000 | Control Hose Bundles, Jumpers, Reels
7098000 | Control Pods
We have over 400 codes; this form will help users find "Major Acct Codes" for the different pieces of equipment we use. So if a user didn't know Control Pods was 7098000, then he would type "Control" and all 3 of those would come up as he was typing, but after he typed "Control P" then 7097000 would disappear and then "Control Po" then 7096000 would disappear.
I need the form to catch any of the words in the MAJORCODENAME field, NOT just from the beginning; so if the user typed "Reel", then 7097000 would show up.
Appreciate the help.
Snayjay