cmd button to open form

[stephaniehpcswf]

I'm trying to use a command button on a form to open a pivot chart and I can't get it to open in pivot chart view, it keeps opening in form view.

[stephaniehpcswf]

I used a macro on my command button. I was able to select the view that pops up.