Reports, filters and crosstabs

I am using VBA to determine which query sits behind a report,
depending upon the preferred sort order. This has worked perfectly
for ordinary select queries behind reports, but it seems to be
struggling with crosstab reports. It presents a "jet engine" error.
Do you know if this is an issue, or is there a better way of doing
this?

Thanks in anticipation.

Cassie

The sort order of the query is often irrelevant to the presentation on the
report.
It's better to set the sort order as a property of the report itself.
I'd suggest the report's OnOpen event as the place to do this.

HTH
- Turtle

"Cassie Pennington" <cassie.dowling@btinternet.com> wrote in message
news:473882f8.0409191032.447cabf2@posting.google.c om...[color=blue]
> I am using VBA to determine which query sits behind a report,
> depending upon the preferred sort order. This has worked perfectly
> for ordinary select queries behind reports, but it seems to be
> struggling with crosstab reports. It presents a "jet engine" error.
> Do you know if this is an issue, or is there a better way of doing
> this?
>
> Thanks in anticipation.
>
> Cassie[/color]

Oh, and if you're filtering a crosstab query using parameters (e.g.
referencing controls on a form), be sure to declare those parameters
explicitly using the parameters dialog (Query - Parameters).


"Cassie Pennington" <cassie.dowling@btinternet.com> wrote in message
news:473882f8.0409191032.447cabf2@posting.google.c om...[color=blue]
> I am using VBA to determine which query sits behind a report,
> depending upon the preferred sort order. This has worked perfectly
> for ordinary select queries behind reports, but it seems to be
> struggling with crosstab reports. It presents a "jet engine" error.
> Do you know if this is an issue, or is there a better way of doing
> this?
>
> Thanks in anticipation.
>
> Cassie[/color]