Creating a form to run a Query And export/save as an Excel

[DouglasLB]

I have a query that I currently run/export as an excel workbook that asks for a date range, and a few other criteria.

I would like to create a form that i can enter the criteria (ie date range and some other things. I have made one for running a report but how do I get it to run the query. And I also want to have a field to enter what i want the excelworkbook that will be created named.

Do I have to make a module? Macro? or do the commands go into the properties window for the command button on the form?

I did recieve some help on my original question, but I dont know enough about Access to make it work.
thread702-153459 would I go about this and what would the macro look like?

Thanks,
Douglas

 

[tomschafer]

If you want to use a macro check out the SendObject action.