Trouble defining variables - Access Module

[David92595]

Hello,



I am having problems opening up a windows shell to a file path in a Module Function. I have it working as a sub, but am trying to convert to a module so it can be centrally located.

I can get a basic explorer window to open
RetVal = Shell("explorer.exe ")

However, when I try to put in a file path with variables I start getting errors. I think my problem is defining the location of my variables. Particularly, LN (Loan Number) and Client_Name
Here is my code:

Hello,

I am having problems opening up a windows shell to a file path in a Module Function. I have it working as a sub, but am trying to convert to a module so it can be centrally located.

I can get a basic explorer window to open
RetVal = Shell("explorer.exe ")

However, when I try to put in a file path with variables I start getting errors. I think my problem is defining the location of my variables. Particularly, LN (Loan Number) and Client_Name
Here is my code:

apath is a needed secondary variable. There are cases where I have to do some case specific changes to LN.

As Always, any help would be greatly apprechated.
Thank you,
David92595

P.S. would a Me.control work in a module?

[June7]

You did not post code. Accidentally copied your narrative.

Me is an alias for the form or report object the code is behind so no, will not work in a general module.