Eval Question

[Turner]

I am trying to call a function using a variable. I
attempted the following code but I am getting an error:

"2425 The expression you entered has a function name that
Microsoft Access cann't find".

Public Function myStuff()

Dim stMsg As String
stMsg = "MyMsg()"

Eval (stMsg)

End Function

Public Function MyMsg()

msgbox "I am here"

End Function

Thanks!!

 

[ka]

Hi,

I copied your code directly into an Access module and tried, it works on my
side....
Could it be your Ms Access installation?

Try on another computer.

Cheers

ka