>>About Craig's way with to different BMP. In early version my class I do it, and this work fine on lettle tables (~50 recs). But with recs > 1000 I had trouble: when I scan through list pictures periodically disappears... I hadn't time to solve this problem and realize idea above.
>
>If you've got 1000 items in a list, it is too many. It would be very difficult for a user to select the correct item, not to mention the performance hit.
Thanks for your respond, Craig.
Yes, you right, it is TOO many.
But which the best way for this situation, f.e.?
Our company has big list of food commodities from different suppliers in different countries in Europe. Some of theirs produce potatoes, f.e., in various packing. We have three-tier classifier of goods: Supplier-Product-Packing.
But my chief said: "I want summary for ALL potatoes and ALL pasta!!!". He is chief...
In report form I'm call my ListBox, type first letters POTA, select ALL potatoes and run report. Chief is happy, me too ;-).
Regards,
Dmitri Alexandrov