Spilt form filtered data to excel export. (1 Viewer)

[JayAndy]

Hi Everyone

I am trying to export the data l have filtered in the Spilt form but can't find how to do it anywhere.

Some of the fields that l wanna export are not visible in the top half but are visible in the datasheet at the bottom.

Does anyone know if this can be done.

 

[GohDiamond]

Your Datasheet is your RecordSource in the form, your criteria is your Filter, and you may be using Order By. Those parameters are addressable and can be captured for use in a dynamic SQL Statement. Then you can export the data in the SQL Statement using TransferSpreadsheet acExport etc etc etc

ex forms!yourformname.recordsource, forms!yourformname.Filter, forms!yourformname.Orderby or something like that.
Cheers
Goh

Here's an Example I tested:
"SELECT * FROM " & forms!YOURFORMNAME.recordsource & " WHERE " & forms!YOURFORMNAME.filter " ORDER BY " & forms!YOURFORMNAME.orderby & " ;"