In Access (I'm actually using Access2007), when I use a Wizard to creat a Combo Box on a form to look up a value in a table, Access creates the attached Macro to occur on the "On Update" event of the Combo Box. It directs Access to do its normal string search, starting at the beginning of the string. The Database that I am working on needs Access to look for ANY word in each string in a particular fiend of the form's Table. In other words if the word "tree" is the 3rd word in one of the strings in this particular table field, I want Access to find that string. In fact it would be preferable if Access were to either give me all the strings that contain "tree" and let me choose the correct one, or at least find the first string, that contains "tree", and let me keep telling it Next, until it gets to the string that I want.
I'm sure many of you have done this thousands of times, as it has to be a pretty common need. Would someone please tell me how to accomplish it via either a modified Macro or via VBA?