Function not working in Query

[MEG]

I have created a function, FIND_LINK, as a VBA module
within Access. I have tested it using a VBA subroutine
and it works correctly.

I have saved the module.

When try to call the function from a query, I get the
following error:

FIND_LINK is not a valid name.

If I use BUILD, I can drill down and find the function in
the database function list.

What am I doing incorrectly?

THANKS,

MEG

 

[Andre Uys]

Meg,
I am not an expert, but don't think you can call a function from a
query.

Sounds like you will have to create a data set using code, and then call you
function per record to execute whatever FIND_LINK does.

 

[John Vinson]

What am I doing incorrectly?

I have no idea, since you didn't tell use what you're doing. Please
post the SQL.

 

[GreySky]

" I am not an expert, but don't think you can call a
function from a query."

Yes you *can* use functions in queries. Function must be
public functions in a standard module.

Meg, I don't know why you can't use it. Are you sure your
arguments are correct? As John mentioned, it would be
helpful to see the code.

David Atkins, MCP