Opening a spreadsheet with filtered data.

[mdub]

Hi,

I am trying to use "DoCmd.TransferSpreadsheet...." to transfer data to a
spreadsheet that displays only the filtered data on a form. Right now, it's
giving me all of the data in the table. Thanks,

Michael

 

[Alex Dybenko]

Hi,
you need to read current form's filter using .Filter property, build a new
query using form's recorsource query and current filter and then use this
new query for DoCmd.TransferSpreadsheet

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com