Exit Function and Subroutine in Access 2002

[Ray]

Hello All,

I have a sub routine that calls a function. When certain
conditions are met in the function, I've used an exit
function command to exist the function.

However, the program resumes on the next line of the sub
routine that called the function.

How can I exit the function and also exit the sub routine
on the line following the call of the function.

Also, how can I determine what sub routine called a
function within the function itself.

Thanks in advance for your time.

Ray

 

[Alex Dybenko]

How can I exit the function and also exit the sub routine

on the line following the call of the function.

you have to return some "error code" in function, catch it in sub and then
exit there also

Also, how can I determine what sub routine called a
function within the function itself.

i think only if you pass sub name as argument to your function

 

[ray]

Thanks Alex!!

-----Original Message-----

you have to return some "error code" in function, catch it in sub and then
exit there also


i think only if you pass sub name as argument to your function


--
Alex Dybenko (MVP)
http://Alex.Dybenko.com



.