Opening a PivotChart from switchboard

J

jaworski_m

I have a form with a PivotChart as a default view.

I would like to open the form (as a chart) from Switchboard pane, but
there's only a possibility to open a form in :
Const conCmdOpenFormAdd = 2
Const conCmdOpenFormBrowse = 3
mode.
That results that the form is not opened as a chart.

How can I avoid that?
Thank you for suggestions.

Win XP
Access 2003
 
D

Daryl S

Jaworski -

The beauty of the switchboard is you have very little coding to do, but you
pay the price in limiting the functionality. If you don't change your menu
items in the switchboard, then you can alter the code behind the buttons to
trap the one that opens the chart, and set the option there - something like
this:

DoCmd.OpenForm "formname",acFormPivotChart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top