sub and function compile problem

[aperture]

i have a public function in a db module called within a private sub in a forms class module. the function is on the right side of an equals sign as follows, without the specific call command:

private sub a

curb= function c (params)

end sub

if the parameters are correct, and they have the correct scope, (which i believe they are and do), why would i recieve a 'sub or funtion not defined' error? am i trying to do something that cant be done?

if someone with more vba expereince can answer this question, or offer insight, i would really appreciate it.

thanks!

ap

 

[rewdee]

Try taking the paranthesis out as:

curb=c params

VBA will evaluate the expression in paranthesis which can change the value passed.

Hope this Helps,
Rewdee

 

[ogri]

Hi

Do you really mean that you have "function" before the function name when you are calling it?

All the best

Keith

 

[jimmythegeek]

No, you don't need the "function" when you are calling it.

If you have the following function:

Function GetData(Par1 As Long, Par2 As String) As String
......
End Function

The call would look like this:

x = GetData(35, "Value&quot

It is always good practice to preceed it with "Public" if you want to get to it from the entire database:

Public Function GetData(Par1 As Long, Par2 As String) As String
Jim Lunde
compugeeks@hotmail.com
Custom Application Development