ACCESS FEED: Re: [MS_AccessPros] Proc

Kamis, 12 April 2012

Re: [MS_AccessPros] Proc_Exit

John,

Would I put "Exit" in the code to send it to Proc_Exit?

Thanks again!
Connie

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Connie-
>
> No. Exit Sub leaves the code without executing anything else.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -------------------------------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Thursday, April 12, 2012 5:12 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Proc_Exit
>
>
> Good morning/afternoon all!
>
> I have the following near the end of each procedure:
> Proc_Exit:
> Exit Sub
>
> If an early exit is required does "Exit Sub" in the code before this then go
> through the Proc_Exit?
>
> Thanks!
> Connie
>