I am trying to export a query upon exit from a form into excel. I have a macro set up to execute upon exit from the form. The transfespreadsheet action will work. However, I am exporting the same query with multiple variables. For instance, I will enter customer information into the form, and upon exit, would like to export a query based on the form to excel, either a new worksheet or simply adding to the end of the data in the main sheet. Any suggestions on how to accomplish this.

Thanks for any suggestions.

Answered in Access forum post.