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

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/...UBED1=ACCESS-L

"Mj Mann" <Mj (E-Mail Removed)> wrote in message
news:42635CD5-295C-4946-91B0-(E-Mail Removed)...
> 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

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

THANKS!!


"Roger Carlson" wrote:

> 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/...UBED1=ACCESS-L
>
> "Mj Mann" <Mj (E-Mail Removed)> wrote in message
> news:42635CD5-295C-4946-91B0-(E-Mail Removed)...
> > 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
>
>
>