This topic is a bit older, but the solution for that is to put the default "Page N of M" that exist in the report controls to force the report to make a second pass.
The author of the code said that : "Until access has finished formatting the report for the first pass, the value of the Pages...