Opening Query in Pivot Chart View

[jabaker54]

So I have a code that opens a query but I want the PivotChart to show. Below is my code related to opening the query.

If vartyp = 0 Then
varQueryName = DLookup("Query", FileName, Criteria)
If IsNull(varQueryName) = False Then
DoCmd.OpenQuery varQueryName, acNormal
End If

 

[JHB]

Create a form with a graph object in it, base the graph on a query.
Use the wizard to create the graph object.
In your code, instead of open a query, change it to open the form with the graph.

DoCmd.OpenForm "YourFormNameWithTheGraph"

Here is a link to description and sample, how to Create PivotTable or PivotChart views in a desktop database:
http://office.microsoft.com/en-gb/a...-views-in-a-desktop-database-HA101901543.aspx