I have an Access form where a user chooses from a drop down list the person they want to send the info to.
Access exports a query to an Excel file. It needs to overwrite this file each time for a new person.
It works fine for the first 2 people. When I go to the 3rd or 4th person, it stops overwriting the Excel file.
In the attached file, it's form frmVacyQuestMgrsORIG
Please let me know what I'm doing wrong.