Open form in pivot chart view

[BZeyger]

I have an Access VBA database which I have created. There is a section of the
database that has the user click a button and a pivot chart is supposed to
appear. However, when the user clicks the button, the form opens in a single
record view. To get it to appear in pivot chart view, I have to right click
and select pivot chart. The form has the ability to cycle through each
record. I do not want this view. I want to click the button and the pivot
chart opens. How would I do this?

Right now the code I have to open the form is:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Chart View 2007"
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[JulieS]

I have an Access VBA database which I have created. There is a
section of the
database that has the user click a button and a pivot chart is
supposed to
appear. However, when the user clicks the button, the form opens
in a single
record view. To get it to appear in pivot chart view, I have to
right click
and select pivot chart. The form has the ability to cycle through
each
record. I do not want this view. I want to click the button and
the pivot
chart opens. How would I do this?

Right now the code I have to open the form is:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Chart View 2007"
DoCmd.OpenForm stDocName, , , stLinkCriteria

I believe that if you set the default view property of the form to
pivot chart, you should be all set. That way, whenever the form is
opened, it will open in Pivot Chart view. The other option is to
include acFormPivotChart in the DoCmd.OpenForm line.

I hope this helps.
Julie

 

[BZeyger]

I set the default view to Pivot Chart and it still appears as single record
data form. I cannot figure out how to have it open directly as a pivot chart.

 

[JulieS]

Okay. What happens when you include the view command in the code to
open the form?

 

[BZeyger]

Including acFormPivotChart did the trick... Thanks

 

[JulieS]

Glad to hear it worked. Thanks for the feedback.