Prev: returning the path of a linked table in VBA
Next: Running Variable-Named Functions with Arguments
From: G on 12 Feb 2010 09:47
This is probably an easy question, but can't seem to find the answer. I
want to cancel ALL public and private subs on an IF THEN statement.
Basically, I'm calling a PUBLIC Function (which runs a public sub) from a
Private Sub. depending on certain criteria from the Public Sub, I want to
exit the Private Sub (also).

Is there a command for this?

Thanks, in advance, for your help.

G
From: Allen Browne on 12 Feb 2010 11:01
No.

Use the return value from the function (or one of the arguments passed to
it.) Test the value after calling the sub, and exit if appropriate.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"G" <G(a)discussions.microsoft.com> wrote in message
news:2FEAB0D8-AD0E-4D20-A072-F9115F86635B(a)microsoft.com...
> This is probably an easy question, but can't seem to find the answer. I
> want to cancel ALL public and private subs on an IF THEN statement.
> Basically, I'm calling a PUBLIC Function (which runs a public sub) from a
> Private Sub. depending on certain criteria from the Public Sub, I want
> to
> exit the Private Sub (also).
>
> Is there a command for this?
>
> Thanks, in advance, for your help.
>
> G

 | 
Pages: 1
Prev: returning the path of a linked table in VBA
Next: Running Variable-Named Functions with Arguments