Export data from filtered subform to Excel ?

[juvi]

Hello,

I have got a form with a subform. The subform's recordsource is a saved
query, which selects data from some tables. The user has the option to filter
the form which I implemented with:

'SQLstr is my filter string
Me.ufo_reports.Form.Filter = SQLstr
Me.ufo_reports.Form.FilterOn = True

This works fine. But now I want to export the filtered data to Excel. I use
the following code, but it exports me everytime the full data (not filtering):

'ufo_reports is the subform
DoCmd.OutputTo acOutputForm, "ufo_reports", acFormatXLS, "ufo_reports.xls",
True

Why is this not working and how can I export the filtered data to Excel? thx
for any help in advance.

BR
juvi

 

[ryguy7272]

You do a Query, and then write the SQL to the TransferSpreadsheet routine.
Does that make sense? Can you work with this
http://www.access-programmers.co.uk/forums/showthread.php?t=145112&highlight=copyfromrecordset

Tinker with it a bit. If you can't get it working, post back with your SQL
(I don't think all of it is in the post).

Good luck,
Ryan---