First and foremost, I would advise against a filtered table as they are slow. For what you are doing I would use a SQL SELECT to a cursor for the record source. HTH
>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
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.