Need Command Button to Pull Up A Pivot Table

J

jillian.calderon

I put a command button on the form and directed it to the pivot table I
created. I saved it and opened the form, but the command button doesn't
lead to the pivot table. How can I get the command button to open in
Pivot Table Form instead of just the form? Thanks! <3 Jill
 
G

Guest

goto the built event of the command button .i.e click event of the button
and add the
DoCmd.OpenForm "pivottable name",acFormPivotTable
dats it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Command Button to Pull Up A Pivot Table 1
My new pivot table doesn't save 1
Access 2003 pivot table subform 0
Access Automatically Send a notification email once a record is added 0
Pivot Table Opens as Form View 1
Link/Bound Pivot Chart to a Pivot Table in Access Form 1
Show Pivot table field list 2
open form in pivot table view, from another form 2

Top