I open the query so that I can double check that everything has worked properly, it the number of sheets in the print-preview matched the record count.

I don't see how me opening the query prior to the report would change the fact that I only get 2 of the records when not debugging the code.

Regards
Darryl

I Should also mention that if I step through the code line, by line there is no problem, but if I run straight past the OpenReport line, then there is a problem.

I have no idea what is going on.

I were using a proper language, I'd compare the machine code from both the debug and non-debug compiles and see what's going on, but being a relative VBA noob, I'm more than a little stuck.

Regards
Darryl

SQL of parent Query:
SELECT CommRefQuery.In stallCompl, CommRefQuery.Co mmDocCirc, CommRefQuery.Co mmComplete, CommRefQuery.Co mmisioningItem, CommRefQuery.PT ermR, CommRefQuery.Ex tTag, CommRefQuery.Se ctInd1, CommRefQuery.[Comm Sht Ind], CommRefQuery.Ty pe, CommRefQuery.De scription, CommRefQuery.In stallComplDate, CommRefQuery.Me chFICReq, CommRefQuery.Me chFICPerformed, CommRefQuery.Co mmDocCirc, CommRefQuery.Co mmDocCircTo, CommRefQuery.Co mmDocCircDate,...

I have just subscribed to this thread

Hi All,
I've got a Recordset that stores a summary (no duplicates) of a field in a query.

This particulary field gives the index for the query/report that needs to be called, ie:
1. I have a number of records that are of interest (pulled from the dB from a query)
2. Each record in dB has a type, this type is the trigger for the query/report that needs to be run for it
3. There are 16 types
4. ...