Running Macro from Combobox using Command Button

[MTSPEER]

Hey guys,



I have a combobox with multiple different macros to choose from, and I'm trying to make it so when the user selects a macro from the combobox and presses the command button the macro will run. The only way I can think about making this work is using case statements for all the macros, but I'm just wondering if there is an easier way.

Thanks!

[CJ_London]

in the combo after update event put

docmd.runmacro me.comboname

[CJ_London]

sorry - that code should go in your button click event

[MTSPEER]

Shouldn't I put that in the command button? Sorry this is the first time I've ever done this before. What should the row source type be? or shouldn't there be one? Do I have to write code for the combobox to put the values in then DoCmd.RunMacro in the command button?

[MTSPEER]

Nevermind I figured it out! Thank you

[CJ_London]

Yes - I posted a second post to correct it

you said 'I have a combobox with multiple different macros to choose from' So I assumed you already had a solution to this question

What should the row source type be? or shouldn't there be one?

However I would suggest you make the rowsourcetype 'value list' and in the rowsource enter the names of your macros separated by a semi colon - macro1;macro2;macro3 etc

Do I have to write code for the combobox to put the values in

no

then DoCmd.RunMacro in the command button?

yes - as previously advised

[MTSPEER]

Thank you sir!