Hi,

I have a search form that displays a list of all records in a table. There are 5 combo's on the form that the user can select a value from to filter the list to only show records that match that value. (Each combo relates to a different field.)

The problem I have is when there are in excess of 10,000 records. I cannot find a way to successfully update the list in a short amount of time with this number of records. I have tried using a listview control and using code to add a line for each record and I have also tried filtering an ADODB recordset that a Datagrid is linked to. Can anyone help with a suggestion or has had this problem themselves?? It can take up to 20 seconds to requery the list when running on a local machine. I hate to think how slow this would be across a network!!

Thanks for your help.

TC

Technical stuff:
VB 6.0 form using ADO to connect to an Access database via a file DSN. Passing a SQL string to the ADO connection each time a selection is made (In tests this has proved quicker than have a stored procedure and passing parameters). I intend to upgrade the back end to SQL Server but it must be able to work on both for now. The data being shown and filtered is all text.