PivotChart Opening As Form

[themurph2000]

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]

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

DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria

...instead of this...

 DoCmd.OpenForm stDocName, , , stLinkCriteria

Good way to waste half of my Friday, huh?