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.