Error While Paging

[estewart]

Two Users are receiving the following error while they are
trying to page through a report in preview mode. All
other users can do this fine. What could be the possible
cause? I have check the references already.

This expression is typed incorrectly, or it is too complex
to be evaluated. For example, a numeric expression may
contain too many complicated elements. Try simplifying the
expression by assigning parts of the expression to
variables.

Thanks

 

[Duane Hookom]

Is there any code in the report? Is the report's record source somewhat
complex? What is the SQL of the report's record source? Are all users on the
same service pack of Office?

 

[estewart]

Thanks, I had a subreport that was running several
queries, so I changed it to run from a table that is
created before the report is opened. This corrected the
problem.