Calling a Procedure from an update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Change you Sub to a Function that returns the required value.

--
HTH
Van T. Dinh
MVP (Access)



Peter said:
Hi
I have a pre-defined procedure within a module which I'm trying to call
Click to expand...
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.
 
Back
Top