Open a form with a pivot table

[wvdw]

Hi,

I created a form that has a pivot table as object on it. But when I open the form I always see the data that is the source of the table. I have to use the mouse to see the chart. How can I open the form and see the chart at once? Saving the form with the chart open does not do the trick. And I can not seem to find a procedure that changes the format in VBA?

Any Ideas?

Thanks.

 

[vbajock]

Create a MAKE table query, and use the Pivot table query as it's data source. Base your form on the made table instead of the Pivot query. I don't know why Access does this - perhaps one of our more enlightened contributors know.

 

[wvdw]

Thanks,

I will try that. I also found that there is an option on the docmd.openform command that opens the form in chart view.