By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

Jump To End Of Loop

P: n/a
See line beginning with WHAT GOES HERE .....

Do Until .........................
Code
....
....
If .............. Then
WHAT GOES HERE TO JUMP TO THE END OF THE LOOP AND LOOP AGAIN
End If
Processing Code
....
....
Loop

Thanks,

Sandy
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sun, 18 Jan 2004 00:34:07 GMT, "Sandy" <sm*****@earthlink.net>
wrote:

Exit Do
-Tom.

See line beginning with WHAT GOES HERE .....

Do Until .........................
Code
...
...
If .............. Then
WHAT GOES HERE TO JUMP TO THE END OF THE LOOP AND LOOP AGAIN
End If
Processing Code
...
...
Loop

Thanks,

Sandy


Nov 12 '05 #2

P: n/a
The Exit Do will jump you completely out of the loop, not take you to the
end to loop again. Instead try:

Do Until .........................
Code
...
...
If .............. Then
WHAT GOES HERE TO JUMP TO THE END OF THE LOOP AND LOOP AGAIN
Else
Processing Code
...
...
End If
Loop

Since you only want the last part to run if the If statement is False, place
it in the Else portion of the If statement.

--
Wayne Morgan
Microsoft Access MVP
"Sandy" <sm*****@earthlink.net> wrote in message
news:3w*****************@newsread1.news.atl.earthl ink.net...
See line beginning with WHAT GOES HERE .....

Do Until .........................
Code
...
...
If .............. Then
WHAT GOES HERE TO JUMP TO THE END OF THE LOOP AND LOOP AGAIN
End If
Processing Code
...
...
Loop

Thanks,

Sandy

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.