Public Function Problem

[david_johnson_CR]

Greetings!

I'm trying to use code designed by Allen Browne. I've followed his instructions (I'm pretty sure) on how to use the code and setting up the function. When I get into the query and when I type in "concatrelated" it even offers the tiny box that shows all the variables I need to enter as with the standard Access functions. I type them in but when I try to run the query I get "Undefined Function 'ConcatRelated' in Expression". I'm not sure if there's a step I'm skipping but it seems to recognize the function until I actually try to execute.

Is there something specific I have to do to "enable" public, user-defined functions?

Thanks so much for any help you all can provide!!

 

[CJ_London]

nothing specific - it needs to be a public function in a standard module (not a form module). Suggest post the full sql to your query

 

[Minty]

Also don't call the Module you saved it in ConcatRelated, as that will break things.
Call it something like modFunctions or similar.