Compile error: loop without Do

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mj Mann - 22 Feb 2005 15:55 GMT

I get this error when I run the code or compile. The Loop DOES have a Do.
The only thing I can think of is that I have too much in the Do/Loop. Is
there a limit? I can't figure out why I get this error. Everything is where
it should be. The code ran before, then I added some more lines then it
started to give me this error.

Help
Mary

Reply to this Message

Roger Carlson - 22 Feb 2005 16:03 GMT

This error can also happen if you have an IF statement in the loop without
an END IF or something similar to that. The key is in the new lines you
added. There is no limit to how many lines can be in a DO LOOP.

Signature

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> I get this error when I run the code or compile. The Loop DOES have a Do.
> The only thing I can think of is that I have too much in the Do/Loop. Is
[quoted text clipped - 4 lines]
> Help
> Mary

Reply to this Message

Mj Mann - 22 Feb 2005 16:33 GMT

That was it. I had a bunch of If statements - hard to track those :-) I
didn't think it was a "limit" issue.

THANKS!!

> This error can also happen if you have an IF statement in the loop without
> an END IF or something similar to that. The key is in the new lines you
[quoted text clipped - 9 lines]
> > Help
> > Mary

Reply to this Message