vbOKCancel BREAK?

[tomatojo]

Hi, I'm using VB in an Access 97 program I have. I'm using the vbOKCancel message box command. But it runs in a look and sometime (during program testing) I want it to break out of the loop. Now, if I click OK, it continues with program as planned (works well). When I click Cancel it skips over the step (as planned) and goes to the next item in the loop (If-Then loop). But every once in awhile, I need to Break out of the loop completely. How do I accomplish this? Is there such a thing as vbokcancelbreak?

 

[PWise]

how about using vbYesNoCancel

 

[PWise]

and on vbno

exit do

 

[tomatojo]

How do I exit and If Then statement (like I'm using)? I keep getting errors (missing end if with if statement, and as far as I can tell, its there!). It worked when it was a vbOKCancel so maybe it doesn't work with vbyesno?

 

[PWise]

can you please post your code

 

[tomatojo]

Got it working now, I just used Exit Sub instead of Edit Do. Thnx!