Find or scroll to and Select a Listbox item from a value in a combo box. HELP!
Posted on 2004-11-29
I have a listbox with many items. To enable faster searching, I have a combo box based on the same query as the listbox. When a user chooses an item from the combo box, I want the listbox to scroll to and select the item. This is a multi-select list box that acts as the basis for building a recordset for a report - so please don't suggest switching to some other control. The multi-select box is necessary. What shouldn't be necessary is having the users scrolling all day to find the entries they want. I know about the pressing of the first keystroke going to the first matching item as well, but its not enough.
I have tried using listindex to no avail, and have searched all the properties and methods also, but I can find no way to do this. Any help much appreciated - because of urgency of project I'm offering lots of points! Thanks in advance...