05-25-2012, 10:21 AM #9 The report has subreports for each of the room elements such as doors, hardware, finishes, etc. Once for the VBA recordset, once for the report. Thanks to all for your comments. 0 LVL 56 Overall: Level 56 MS Access 55 MS Applications 13 Message Active today Expert Comment by:Jim Dettman (Microsoft MVP/ EE MVE)2009-06-09 You
Consider a saved QueryDef with this SQL: SELECT tblInventory.* From tblInventory; Running that QueryDef uses TWO table handles. If I get more involved in the future I will explore methods to reduce the subreports since it will also help performance.