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.
Yes, I can confirm that. BTW, if you want to 'simulate' multi-selected listbox, you can use multi-select grid, which you can find here in UT files section. Two grid classes (by Cetin Basoz). On Friday I implemented this class within my own class and it becomes a very nice and handy class. On Monday I'll do some more testings and then probably upload here in UT.
If it's not broken, fix it until it is.
My Blog