Re: Why does this code not work?

"mscertified" <rupert@xxxxxxxxxxxxx> wrote in message news:D3BB5228-4F61-4D5B-9E11-D427E5197C1C@xxxxxxxxxxxxxxxx
No, it gives the same error...
"The expression you entered has a function name that Microsoft Office Access
can't find."


"Dirk Goldgar" wrote:
I'm inclined to think the function Gumbo must be Public. Does that work?


Where are these routines defined? In a standard module or in a form module? If this is a form module, any public procedure on the form is going to have to be qualified with a reference to the form. I've tried this:

Dim strMod As String
strMod = "Gumbo"
Eval ("Forms!" & Me.Name & "." & strMod & "()")

.... and it almost works, but it give an error message after displaying the message box.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

.