>Hello again Fred,
>
>Thanks for the < pre > < /pre > tip! That will come in handy.
>
>You know what -- I found out that the code works great, except when you have hundreds or thousands of records. Then, it's painfully slow. I better try the SQL SELECT command instead.
>
>Too bad. It seemed like a nifty way to shrink a listbox drop-down list by doing a search of a listbox drop-down list. I sound like I am repeating myself.
>
>Have a nice weekend. Thanks.
If your RowSourceType is 0, you can use the .Clear() method to "zap" the list.
And having thousands of records in a list box is probably not a good idea. You might want to use a grid in that case.