Open Pivot Table or Chart in Form

[LJG]

Hi Guys,

I have created 2 forms 1 for a pivot table and 1 for a pivot chart, I want
the forms to open as either a chart or table as designed, however, whenever
it opens does not show me the pivot table or chart and I have to right click
for the menu and select chart or table from the menu.

I have set it as default and set datasheet on form options to no

Can anyone help me with this?

TIA
Les

 

[Guest]

Hi, You should consider these subforms and create a blank form to place them
in. When you open the main form your Pivot Chart will be displayed as you
want it.

Hope that helps.

Thanks, Lawrence