loops

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
loops

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

February 4th, 2005, 12:40 PM

Hudson40

Hudson40 is offline

Authorized User

Join Date: Dec 2004

Posts: 43

Thanks: 0

Thanked 0 Times in 0 Posts

Default

loops

Hi

How do I come out of a loop once a condition is met and stop the program from filtering through to other functions? I

Cheers
Tony

__________________
Cheers
Tony

Old

February 4th, 2005, 12:58 PM

Bonnie Paris Bonnie Paris is offline

Bonnie Paris is offline

Registered User

Join Date: Feb 2005

Posts: 6

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Sounds like you need to use the Exit Sub statement. Check the Access VBA help for "Exit Statement" to learn about the different types of exit statements.

Regards,

Bonnie

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
break for-each loops, or limit amount of loops	warhero	XSLT	2	July 4th, 2007 02:18 AM
Loops	deontae45	VB.NET 2002/2003 Basics	2	September 28th, 2006 03:48 PM
Two Loops	iloveoatmeal	Classic ASP Basics	5	September 26th, 2005 09:59 AM
While loops and For loops in XSLT	spencer.clark	XSLT	1	August 5th, 2005 09:50 AM
Loops	Hudson40	Excel VBA	2	January 20th, 2005 07:40 AM