Creating Macro from Module

[Harley Guy]

Thanks to Rural Guy, I've been able to get the coding to copy one database to another...

Now that has been accomplished, I need to create a macro that calls to the module that I have created.

The module I've created that copys the table to another database is called Archive Current Server List.

I've been looking at the "RunCode" option but I have no idea how to call to the coding in the module to run it.

If I use the "Open Module" option, then it opens the module and you need to run the module from there.

I need to limit users from getting in this area as you know people could inadvertanly screw up the coding.

Any ideas?

[RuralGuy]

I take it you have your code in a Standard Module? Be sure the Module name and the Procedure name are not the same. I would name the Module something like basCode. If you are going to invoke the procedure from a button on a form then you can simply Call the procedure. BTW, embedding spaces in any names will be problematic down the road.