Dynamic functions

[bubu678]

I have functions in a module that I would like to execute by "building" the function name.

example: In module A I have
Function AAA (ByVal Arg1, ... ByVal Argn)


...
End Function

Function BBB (ByVal Arg1, ... ByVal Argn)
...
End Function

Function CCC (ByVal Arg1, ... ByVal Argn)
...
End Function

I would like then to run the appropriate one something like this:
IF case1 THEN
sFunction = "AAA (arg1, ... argn)"
else
sFunction = "BBB (arg1, ... argn)"
END IF

EXECUTE sFunction

Can that be done in Access 2007?

Thanking everyone in advance...

[pbaldy]

Untested, but you can try wrapping it in the Eval() function:

Call Eval(sFunction)

[ajetrumpet]

if eval doesn't work, just call the specific function under each case statement. there's nothing wrong with that either.