I have a list box that is set to multiple select. The problem is that there are a few hundred selections in the list, so it's a hassle for the user to scroll down to get what they need.

What I'd like to do and I don't know if this is possible but to have a combo box with the same data as the list box, so when the user types in the record they need and it appears in the combo box, once they hit the enter key, it will highlight the record in the list box. Does anyone know a way to do this? Any assistance would be appreciated. Thanks.

Here is some info on Stephen Lebans' site on scrolling within a listbox from code.

In the After_Update event of your combobox, you could scroll to (and mark as selected) the item in the listbox.

Hope this helps.

Thanks. After much frustration, finally figured it out and wouldn't you know it? It involved very little code. Guess, I was trying to over complicate it.