Export to Excel

[milte]

Hello all,

I'm not sure of the best way to accomplish this...

I have a query, with parameters, based off of a table. I have a form and subform with the record source from this query. The subform is a datasheet. Fields on the datasheet/subform are filtered by using the filter buttons on the tool/menu bar. On the mainform, I have text boxes which give the quarterly totals (qtr1, qtr2, etc.) As I filter records in the subform, the quarter totals on the mainform change.

Here's my problem: I have an button to export the subform datasheet to excel. it works fine. It's based on the query with my parameters. What I would like to have happen is the datasheet that I filter, using the menu/tool bar buttons, be exported to excel. Is this possible?

Let me know if you need more clarification.

Thanks,
Mike