Slow queries - is it possible to cache the results

[LeighW]

I have a subform (Formatted as a Datasheet) on a form, the form also has 3 buttons each button changes the record source of the subform to a different query (all with the same fields). The problem is that the queries take about 5mins to load / display as they are quite complexed queries formatting upto 260,000 records. So each time the user changes the record source of the subform (by clicking the buttons) it takes ages to load / display the data. Is there anyway that after the user has viewed the data once it is some how cached so that if the user goes back to that record source the query does not have to run again. In other words once the query has run it stores the results and next time it is run does not requery the data.

Hope this makes sense and I hope someone can help…

Thanks


Leigh Walker