PivotChart Opening As Form (1 Viewer)

themurph2000

Fat, drunk, and stupid
Local time
Yesterday, 20:37
Joined
Sep 24, 2007
Messages
181
I'm sure this has been discussed before, but have any of you made a pivot chart, and then went back and made changes, only to have the form open up as a single form? I already checked the properties, and nothing was changed there. And ordinarily I wouldn't use Access to make a chart, but the higher-ups have overruled me. (No matter how much I tell them charts in Access are stupid.)

Any thoughts? I'm doing a lot of :banghead: right now.
 

themurph2000

Fat, drunk, and stupid
Local time
Yesterday, 20:37
Joined
Sep 24, 2007
Messages
181
To quote Emily Litella, never mind!

In the VBA code behind the button that would call the pivot chart, it was formatted to open up the form as a single form rather than a pivot chart. So I needed this

Code:
DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria

...instead of this...

Code:
 DoCmd.OpenForm stDocName, , , stLinkCriteria

Good way to waste half of my Friday, huh? :mad:
 

Users who are viewing this thread

Top Bottom