Compiler doesn't like "Exit While"

[GraeagleBill]

Name: 000.jpg  Views: 13  Size: 82.9 KB  ID: 47444" class="thumbnail" style="float:CONFIG" />

There's nothing particularly special about a my simple While loop, so it's a mystery as to why the compiler is complaining?

I changed the code to a "Do While....Exit Do....... Loop", but why doesn't the Exit While not also work?

[davegri]

Do While works with Exit Do as you discovered.

Microsoft recommends using Do...Loop instead of While...Wend as "The Do...Loop statement provides a more structured and flexible way to perform looping."

The documentation for While...Wend does not offer the Exit structure at While...Wend statement (VBA) | Microsoft Docs

[GraeagleBill]

Yes, the $MS description doesn't offer an example. I often code loops through recordsets using "While..........Wend", but this is the first time in recent memory that I had an occasion to exit the loop. With this caper, I'll start using "Do While............ Loop" structure so I don't bump my head again. Even old geezers can change their ways
Thanks,
Bill