I created a PivotChart based on a query. When I open it by double clicking it opens correctly. But I need to open it by using the switchboard or a button added to the switchboard. When I've tried this the pivotchart opens in a regular form view.
Is there VBA code or a macro I can use to get this to happen? I've tried setting all the views in properties to no and the default view is PivotChart.

There will be managers that know nothing about Access that will be trying to retrieve the charts.


HELP!!
Denice

Edited by: Zababal on Thu Apr 6 15:06:21 EDT 2006.

Yes, you'll need to tweak the code that switchboard manager produces. If for instance you picked Open Form in either mode available, it will open in form view. That is what it does.

A couple of ways to fix it. You could develop a macro that opened the pivot chart as you want it. Then edit the switchboard button so it runs that macro. That is what I would do.

Or you could develop the macro as before, convert it to a module, and edit the switchboard button so it runs that code.

Can anyone get me started on the code?

The simplest way to do it is to develop a NEW macro. The OpenForm command is the one you want. Then just fill in the Action Properties at the bottom of the screen. Save the macro and try it out.

I think I figured it out. But if could still use another way if anyone has one?

I opened a new macro and dragged the PivotChart I wanted to open into the action colulmn. Then I set the View to PivotChart and the Data Mode as read only (just in case). Then I told the Switchboard wizard to open that macro with the button.


Thanks
Denice

Edited by: Zababal on Thu Apr 6 15:27:33 EDT 2006.

You're welcome. I am glad it is working and that I was able to help.