Listview AND rs.FillCache? 1

[boxboxbox]

I have a table with about 50K records. I'm trying to improve the performance of a query on the table, that has four criteria fields, triggered by KeyUp on a form. It filters the results based on what people are typing.

My info is currently in an Access linked table, but I'm testing speeds with MySQL and will switch if need be.
I have tried using rs.FillCache, and doing an ADO.connect through mySQL and both are really fast. However, not only do I want better speeds, I want the column adjustment capabilities of a ListView.

Filling a ListView with all the records takes forever (~10 minutes and sometimes crashes the computer).

1)Is there any way to use fillcache or a similar feature to only fill the list as I scroll up or down?

OR

2)Is there something I could do to base my form on the recordset (ie, continuous forms as I have it now) to maintain the newfound speed, but also be able to adjust column width?

Thanks in advance.

 

[jsteph]

If it's now a form in continuous-forms mode, you could make the form a subform in Datasheet mode and drop it into a 'container' form.

This way you can have your header area, but still have the scrolling of continuous forms and column-adjustability of datasheet mode.
--Jim

 

[boxboxbox]

By Jove! I've been trying to make it far too complex and your solution is so simple. Now I just need to adjust my code to the new container form to load everything properly...Thank you so much!