Return all records from Query

[ysrini]

Hi, when i run a query in the MS Access, it takes few secs and displays the result set
However, when i scroll down the result, the window freezes for several seconds (it's calculating the next records to be displayed) and then displays the next few hundred records

How can i specify to return all records in the result grid so i can scroll the results smoothly?

Thanks


-srinivas

[llkhoutx]

Access merely return the records which are displayed at any one instant, hence the hesitation before displaying more records.