Go to next record without processing current recor (VBA)

Topic

New Reply

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!

Reply | Quote

Replies

Do While Not rst.EOF
‘1 something
‘2 something else
If Not (rst.Field = “X”) Then
‘3 do a step
‘4 do another step
End If
rst.MoveNext
Loop

Reply | Quote

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? 🙂

Reply | Quote

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? 🙂

Reply | Quote

No, VBA only has an Exit Do, but that jumps out of the entire Do … Loop construct.

Reply | Quote

Yeah, I was afraid of that…

Had to try, though.

Reply | Quote

Yeah, I was afraid of that…

Had to try, though.

Reply | Quote

No, VBA only has an Exit Do, but that jumps out of the entire Do … Loop construct.

Reply | Quote

Do While Not rst.EOF
‘1 something
‘2 something else
If Not (rst.Field = “X”) Then
‘3 do a step
‘4 do another step
End If
rst.MoveNext
Loop

Reply | Quote