Form Loading a huge table

[Aqif]

Hi

I've got a Subform which loads a table of about 71000 records by a complex query. The form displays the values in few seconds but keeps of Calculating for a long time before displaying the full values. I have even tried Indexing the fields but still its slow. is there any better way to load the tabular form faster?

Cheers!
Aqif

 

[RichUK]

Do the calculations on the form