Jump To End Of Loop

[Sandy]

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

[Tom van Stiphout]

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

[Wayne Morgan]

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