Open directely to Pivot Table

R

Rose

Is there a way for someone to open directly to a Pivot Table rather then a
query? I tried to use a command button in a form to run the Query but it
will not show a Pivot table unless someone goes up and says view Pivot Table.
 
D

Douglas J. Steele

How are you opening the query? Have you tried:

DoCmd.OpenQuery "MyQuery", acViewPivotTable
 
Top