VBA from a macro

[Peter]

I have written a VBA function module and now want to run it from an Access
macro. I have tried using the "runCode" action and entered the name of the
function on the "function name" line as "functioname()". Access cannot seem
to find the function name. Can anyone tell me how to do this? I am missing
something. Thanks.

 

[Ken Snell [MVP]]

The function must be a Public one and must be in a regular module whose name
is different from the function's name.

 

[Peter]

Thanks. I had given the module and the function the same name.