Help with running a query from the switchboard

[Guest]

I would like some help on running a query from the switchboard, the query is
a pivot chart, I added it to the switchboard with a command button to run the
query. However it opens the query data returned but I would like it to be
able to open the acutal pivot chart instead as the principal will not want to
see the raw data, he will just want to click on the button and open the chart
ready for viewing or printing.

 

[Guest]

Have the switchboard call a macro to open the query in pivot chart view.

 

[Guest]

Thanks so much, that worked, I appreciate your help.

Monique