MS Access Module not found

I am trying to update a SQL database using Access. The module I wrote is parsing a string and adding to the string on the left. For some reason when I run the update query, the query does not find the module I wrote to do the string manipulation. What do I need to do to get the update query to recognize the module?