Macros: I don't understand this. (1 Viewer)

[kriss669]

Should be simple. I have a macro group for my form. The macros run fine individually from command buttons, but I'd like to set them up as values in a combo box to save space on the form. So, I set up a two column combo with the user prompt in one column and the macro names in the second. Problem is, Access tells me that it can't find any of my macros when I try to run them from code that calls the user's selection in the combo. The code identifies the macro names correctly and puts them into my variable string just fine. But an error message says that the macro either doesn't exist or isn't saved, neither of which is true. The Help directs me to reference the macro group name, which I've already done.

Any ideas?

 

[Neal]

Do these functions have to be macros? It might be easier to convert them to VBA and set up a Select Case function off of the After Update property of the combo box. (If you don't know how to convert the macros, click tools, macros, convert macros to VB).