I've read that, but honestly, I don't get how you can do that. When the user clicks on the customer picklist button, they expect to see all of the customers, not just some of them. I have no idea what customer they're going to choose, so how can I possibly guess at a subset? And if I knew which one they wanted, there wouldn't be much point of a picklist. I guess I must be missing something. Or don't anyone else's users need to choose from a list? I know mine don't memorize every record in every lookup table. LOL!

Thanks,

Michelle

----------------------------------------------------------------------------------------

>One of the most important thing in n-tier programming is that your business object should only return small amount of data. Try to do all your processing in the business logic and then the speed wont be a factor back to your form.
>
>ADO can handle large amount of data but again you should always keep your resultsets to a minimum size.
>
>Stephane