[RESOLVED] Export Filtered form data.. Access to Excel

I know u can use transferspreadsheet to export a table to excel...

I have a form, datasheet view, that I would like to be able to export the "current" data... so after the user applies the filter.. only X number of records will spit out to excel.

thanks!

after many failed attempts...
I would up doing a temp maketable on the subreport databoject/source... with the filter. works... not the best solution but it works :)