I have a table that will have between 5,000 and 10,000 records.

I want a list box on the form that will show all or some of the records, based on other settings on the form. What is the preferred source for the list box, an array, a cursor created from a SQL statement or the table that is filtered? Will there be a difference in the response time on the list box?

Thanks

Judy Scofield