How can I create a combobox to run Macros?

[Repent]

Hello All;

I have a form that has about 17 command buttons on it that run different macros. The macros run queries and or reports. The frontend has gotten somewhat cluttered with 17 command buttons on it. How can I put the command buttons/macros in a combo box list so I can save room on the form?

I have three groups of command buttons. One group runs reports, one runs queries, the other runs pivot tables. I'd like the combo box to have three different "sections" with headings for "Reports, Queries, Pivots" so in effect there is only one combo box with three different sections and under the sections the applicable macros are listed as shown below:

Can you please help in step by step fashion? I'm still very new to Access 2010.

Thanks to you all!

Queries
query1
query2
query3
Reports
Report1
Report2
Report3
Pivots
Pivot1
Pivot2
Pivot3
etc
etc

 

[Repent]

looks like I have it figured out. Found an example file.

 

[Repent]

Here is something I'm still investigating. I have my reports and datasheet queries all setup to run from a combo box. Can pivot tables also be run? If so, is there something I have to do different from setting up reports and queries? The queries that were setup to run as pivot tables come out as reports or queries, but not pivot tables.