Jeff
Although you can use the eval() function Stan Leszynski suggests in his book
Access97 Expert Solutions the following.
To execute a function whose name is stored in the Argument field of the
table, the Switchboard Manager includes the following line of code in its
forms:
Application.Run rst![Argument]
Note the use of the new Run method to execute a function whose name is
supplied by an expression. This method provides a simple mechanism for
executing a function without storing the function's name in the calling
code. Previously, you used the Eval() function to run a procedure whose name
was supplied as an expression or variable at runtime. Now, you might prefer
to use Run as it is superior to Eval() in the following two ways:
? Run enables the referenced procedure to be a Sub procedure, and Eval()
only executes a function procedure.
? You can supply arguments to the Run method that are passed to the called
function by placing them after the function name expression, as in the
following example:
' Pass one argument to the called function
Application.Run strProcName, Me.Name
Christopher