Pivot Chart From a Command Button

hello,
I am new to access. I designed a Pivot Chart that i want to be able to call from a command button
and open it so that the data can be manipulated....when i create a command button opening for form
that i named the pivotchart, it opens the form that it creates under the surface...can anyone help me...

i named the pivotchart pvtEquipmentHours

thanks alot for a quick response...

Can you clarify a little by the phrase "it opens the form that it creates under the surface"

lwells

sorry....when you use the wizard to create a pivot chart, i also creates a form that underlies the pivot chart...for example, if you just
double click the pvtEquipmentHours from the forms lists, it opens the pivot chart and you can manipulate the data....but, if you click on
the design button, it opens the form that the wizard makes (like you were going to input data). when i try to call the pivot chart from a command button, it opens the underlying form, not the chart that i need......

sorry for not being clear

You must have made your command button to open the form from the wizard. Just open the code for your command button and insert the acFormPivotChart into the syntax. Something like this

DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria

That will now open your form in Pivot Chart View instead of the form view.

lwells

cool...thanks alot....what is the stLinkCriteria??....when I omit this statement, it still works fine....i really appreciate the help...

stLinkCriteria, is the variable that would hold a specific condition. Something like this in an English translation of VB Code

Open Form named Customers in normal view and show all records "Where the State is Colorado"

The "Where the State is Colorado" is the sql WHERE clause that is often put into a variable and the wizard calls this variable stLinkCriteria by default. You can omit that part of the syntax.

lwells