Compile error: loop without Do

[Mj Mann]

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

 

[Roger Carlson]

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.

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

 

[Mj Mann]

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

THANKS!!