displaying a pivot table view from a switchboard option

[Joe]

I've created some pivot table views compiling some statistics from a
table. I'd like to have the pivot table view displayed directly from a
switchboard option. At present, I only get the table view of what
should be the pivot table view when the choice is made. Any suggestions
on how to get the pivot table view rather than the table view? I can do
it manually after the table view is displayed but I want to have the
pivot table view displayed for some not techie people who use the
database.

I'm using Access 2003.

Joe

 

[Guest]

Hi Joe,

Are you attempting to open a table directly, and then use the View >
PivotTable View menu command? If so, try creating a form instead. Set the
default view to Pivot Table. Or, use VBA code to open your form from a
switchboard:

DoCmd.openForm FormName:="YourFormName", View:=acFormPivotTable


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Joe]

Thanks Tom. I originally did save the form in PivotTable view but the
switchboard manager doesn't have an option to open a form to 'view',
only to 'edit' and/or 'add'. However, the VB code you provided did the
trick for me. I'm not that familiar with VBA so it took quite some time
to figure out where to put the code. It works perfectly, thanks again.

Joe