I am currently trying to run a query from a form. That is the easy bit. When the form user clicks on the run query button on the form, I want the query data to automatically open up in excel only.

Any ideas?

You don't need to run the query. Look up the TransferSpreadsheet Method. The button should execute the TransferSpreadsheet Method, rather than opening the query.