export from an open form

[pierre]

Hi all,

I have a form where a user can select records with listbox
Also he can filter what he want (menu with mouse right click )

I want to export exactly what the user see on his screen to an external
file.

Private Sub cmdExport_Click()
On Error GoTo Err_cmdExport_Click
Dim rst As Recordset
Dim qdf As New QueryDef
Dim strsql As String

Set rst = Forms!frmExport!frmExportSF.Form.RecordsetClone

Set qdf = rst.CopyQueryDef->Unauthorize operation for that type of
object

strsql = qdf.SQL
DoCmd.TransferText acExportDelim, "exportBM", strsql, "test"

How come i have this error?

Regards