and sometimes, at the qryVendHist.refresh command, I get the dialog box that
starts out:

"Run-time error '1004':

The file could not be accessed. Try one of the following:

Make sure the specified folder exists.
Make sure the folder that contains the file is not read-only.
Make sure the file name does not contain any of the following
characters: < ? [ } : | or *
Make fure the file/ath name doesn't contain more than 218
**********

I don't know what possible sense that makes in this context, but if I click
Debug, and then tell it to continue, it usually finishes up fine.

I tried putting in a DoEvents before and after the qryVendHist.refresh ,
but it's still doing it.