Dynamic crosstab report help

[Guest]

Hi,
I have a dynamic crosstab report (much like the example in the
Solutions.mdb) which fills columns based on the fields returned from a
crosstab query.
There are times where the query returns more columns than are available in
the report and the report generates Error 2465. I've managed to show a custom
message box when this happens, but I need the report to stop running at this
point too.
Can anyone suggest a way of trapping the error and stopping the report from
formatting the other sections and generating the same error again for those
sections?

Thanks,
Dave

 

[Duane Hookom]

Don't use the "Solution.mdb" solution since it is slow, code heavy, and
in-flexible. There is a better solution at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.