Dear Larry
thank you very much for the information. I agree with you that there
are better ways to accomplish this. What i have is a generic input box
for any kinds of data. so i need to define the different functions to
validate the data after the user has defined the questions they want to
capture. This will allow flexibility and mini maintenance from IT.
That's one way i feel i could do.
Best Regards
Boon Yiang
Larry Linson wrote:
Check VBA Help for the "eval" function.
That said, there's (almost?) always some better way to accomplish a given
purpose than relying on saving function names and using them in this manner.
Larry Linson
Microsoft Access MVP
<ch****@hotmail.comwrote in message
news:11**********************@38g2000cwa.googlegro ups.com...
Hi
May i know is it possible to run a function when we pass in the
function name as parameter ?
eg retval = functionA(A)
but i would like to have something like :
varFun = functionA(A)
retval = varFun
varFun = functionB(B)
retval = varFun
varFun = functionC(C)
retval = varFun
the reason is becuase i am thinking of storing the function names in a
database field so that based on what is selected, i will run that
function. so in a way, the which function to run is a "variable"
for some advice please
Thank you
Boon Yiang