I am using VB6 and access
I would like to know how to:
In a combo box when I am searching for a specific field. If I type the letter H for example, I would like the closest match to appear after I hit the letter H.
Example if I have words like hello, help, hold, peter, michael etc..... in the database.
If I press the combo box all these names will appear in the drop down box, if I type the letter M, then Michael will appear. Or if I press H, then hello will appear, instead of typing out the whole word, it brings back the closest match.
Also in what event should this code in put into?
In the keypress event?
Thanks very much.