|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
Consider the following:
While Not (rst.EOF)
'1 do somthing here
'2 do something else here
If rst.Field = "X" Then
'go to the next record without doing any of the next steps
End If
'3 do a step here
'4 do another step here
rst.next
Wend
How can I go to the next record without having steps 3 & 4 executed when the “IF” condition is met?
Thanks!
While that would work, my example was an overly simplistic one.
I was hoping for something along the lines of Java’s Break or Continue.
It could be possible to skip to the next record after any of the steps, and there are not only 4 in the real program.
GOTO would work, but I’d be the black sheep of the VBA world, right? 
While that would work, my example was an overly simplistic one.
I was hoping for something along the lines of Java’s Break or Continue.
It could be possible to skip to the next record after any of the steps, and there are not only 4 in the real program.
GOTO would work, but I’d be the black sheep of the VBA world, right?
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
