I wrote a new report using a copy of the system. When it
worked, I copied it and its supporting queries into the
production database. When somebody clicks the button to
run it, Access 2000 reports Error 3071. The line of code
that triggers the error is simply
DoCmd.OpenReport "DepInvTrack", acViewPreview

I tried compacting both databases and copying the tables
from the production database into the one with the new
report. Same error. If I just try to open the report, it
works fine. If I create a new form with a button to open
the report, it works fine. But if I try to open the report
from a button on the main control form, I get this error.

Any suggestions? //Thanks/Zeke Hoskin

"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."

The reason is that one of the operations that Access feels it must do in the
programmatic preview case is simply putting you over the maximum allowed
complexity. This can often happen for complex reports and the actual results
about this sort of thing are not documented; the solution is to simplify the
report a bit.

--
MichKa

Michael Kaplan
Trigeminal Software, Inc.  -- http://www.trigeminal.com/

International VB? -- http://www.i18nWithVB.com/
C++? MSLU -- http://msdn.microsoft.com/msdnmag/issues/01/10/