I have created a report in Access 2007 with several nested subreports that runs just fine in Access 2007. However, when a user opens the database with Access 2010 and runs the report, the 2nd level subreport truncates after about 8 records instead of showing all 27. I opened the subreport directly and the underlying query and verified that all 27 records are presented in both and all 27 records have valid entires in the field that links it to the parent.
I have run this on two different computers with 2010 and get the same problem on both computers.
Does anyone know what is going on here and what I can do to get teh report to run correctly both in Access 2007 and 2010.
David