In looping through a list of client emails to send a unique report, I have to use both:
I can't figure out why both are necessary.
If I remove "docmd.gotorecord,,acnext"
each report is only sent to the first email on the list.
If I remove "rs.movenext" each person on the list gets only the first report (not there data).
the docmd is changing the email address
the movenext is changing the report filter
The code gets the job done but I'd really like to understand why this is doing what its doing.
Side note. If I stop the procedure w/ the real database (100's of records) and then restart, the email address starts over but the reports pickup where they left off.
To avoid the unpardonable sin of sending the wrong information to a client, I kill the form on an error.
Can someone explain why I need acnext and movenext? I need more confidence in this code before I allow others to use it. It just doesn't feel error proof.