Some of the queries are simple (appending maybe 5 or 10 records), and some of them are really heavy duty. However, every time I run the routine the whole display starts to jump up and down (when it reaches the heavy duty queries, I presume), and the only way I can stop it is by bombing out of Access. What's going on? How can I avoid it?
After consulting the help file for Echo, I put that in there as an Application level command, and it seems to have helped. It didn't jump at all. However, interestingly enough, the status text I put in didn't display except in between queries. While running the queries, the default query status bar displayed instead.
It'll work, though, without the text, which I deleted.