undefined function 'xxx' in expression - user function

[Topmark]

The undefined function is a user written public function saved as a standard
module in the same database where the error occurs. I am attempting to use
the function in a query criteria expression.

The function runs and returns the correct information when called from a
test sub. It also compiles without error. There are no missing references
in the module design window under Tools/References.

I know this is going to probably be something really silly, but I just
cannot track down why I cannot run this from my query. Any help will be
appreciated.

Access 2003

Thanks,
Pat

 

[Topmark]

Hi Chris,

Thank you for the speedy reply.

Copied the function name directly from the code but still receive the same
error when attempting to execute the query.

In the course of attempting to get this to run, I actually used the
Expression Builder from the query design grid to insert the function and
parameters into my expression. That all works fine but it still gets the
same error.

Thanks,
Pat

 

[Topmark]

Hi Chris,

Well of course I named the function the same as the module (I said this was
going to be something silly). Did not mean to, but keyed it in that way and
read right over the name multiple times without recognizing it.

Thanks for getting me back on track.

Pat