Switchboard code not visible

[rahulmudiraj]

Hi All,

I have created a switchboard and now i want to change its code in order for it to include the pivot chart

I found the code changes to be done for the same

but i am unable to locate the Form_Switchboard ( in the microsoft VB editor)

how do i locate this , suggestions would be highly helpful please

Regards,
Rahul

[June7]

How did you create the Switchboard - with wizard or manually? The wizard might have used only embedded macros in which case there would be no VBA event procedures associated with the form and therefore would not show in the VBA editor.

[rahulmudiraj]

I have created through Wizard

[rahulmudiraj]

So now there is no way i can incorporate the pivot chart, since i created the Switchboard through the help of wizard?

can you suggest any other means, please

[June7]

Be aware that MS has eliminated Pivot Table/Chart views from Access 2013.

I don't use the design wizards nor macros.

I have never used Pivot Table/Chart views. Why would you want a Switchboard in PivotChart view? Do you want a subform in PivotChart view on the main Switchboard form? I am guessing a subform can be set for PivotChart view.

[rahulmudiraj]

No no no, you got my question wrong

I have 3 reports, 4 forms and 6 pivot charts ( which also get stored as forms in access)

now i want to place all of them in the Switchboard, but the switchboard options are able to accomodate only forms ( in read or edit mode) and reports

when i am attaching my pivot chart as a form, it is showing up in a table format, but not in terms of a pivot chart

[rahulmudiraj]

In doing so, i must change the code of the switchboard itseems ( as per the below link), but unfortunately i cannot access the switchboard code as i have created it through a wizard

http://www.accessmvp.com/JConrad/acc...hboardfaq.html
13. Q: How do I open a
table from the Switchboard?

[June7]

The 'code' is macros and the macros and properties of the form controls refer to a table for parameters. You can alter the Switchboard behavior by editing the table, macros, properties. However, I found understanding this structure harder than my manually built 'Menu' form that uses VBA code.