Macro to fire a module

[MK]

Am finishing up my first Access app. Thanks again to all who helped along
the way.

Need the user to import a table into Access, then fire the module I wrote.
I've been
going into the vba editor and hitting run from the menu to fire the module.
Is there
a better way ?

Thanks - Mike

 

[Allen Browne]

You cannot run a module.
You can run a Sub or a Function in a module.

Assuming that the code you wish to run is a function (not a sub), use the
RunCode action to fire it from your macro.

 

[MK]

Thanks.

I changed my sub to a function and was able to do the macro.