Calling a Procedure from an update query

[Peter]

Hi
I have a pre-defined procedure within a module which I'm trying to call from an update query. If i enter the update value to be Proper([field]) where proper is the name of the routine in my main module, I get an error message saying that it's not recognised or it can't be found. I've tried changing the statement to Call Proper([field]) but that doesn't work either.

Does anyone know how to call a procedure from within an update query?

Thanks in advance for any responses.

Peter

 

[Van T. Dinh]

Change you Sub to a Function that returns the required value.

--
HTH
Van T. Dinh
MVP (Access)

Hi
I have a pre-defined procedure within a module which I'm trying to call

from an update query. If i enter the update value to be Proper([field])
where proper is the name of the routine in my main module, I get an error
message saying that it's not recognised or it can't be found. I've tried
changing the statement to Call Proper([field]) but that doesn't work either.