Do you have any dlookup commands in any of the fields? Are the key fields you're sorting on indexed? Are there any If/then... statements which could be delayed or not computing the data on these pages? Do any of the field values of the records in these 2 pages look odd or wierd compared to the other data? Is there any data which is causing a lot of page reformatting (ie. growing of fields) on these pages? Try changing the recordsource query properties of the report (recordset type property) to a snapshot.
You can also try creating another copy of the report and set it so the query just queries the specific page 137-138 data and see if that is taking a while or freezes.
Last edited by pkstormy; 10-24-07 at 10:39.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)