Export Subform Filter to Excel

[accessNator]

I know that this question has been asked many times, but I can't seem to find the proper solution.

My subform is filtered via using VBA.

e.g.

strFilter = "[FK_D_TO_ID] = " & passProgram & " AND [isPending] = " & Me.txtIsPending & " AND [isApproved] = " & Me.txtIsApproved 
Me.sfrmContainer.Form.RecordSource = "qry_WorksheetFund_Status_TollFree"
Me.sfrmContainer.Form.Filter = strFilter
Me.sfrmContainer.Form.FilterOn = True

It works as I expect to see in my Subform.
Now I want to export the results out to excel.

The problem is that I want to only export what is actually being viewed on the subform. Not the underlying query that it uses which has many more columns that are not displayed on the subform.

Is this possible?

Better yet, is it possible to use the result being displayed on the subform and make that into a temporary table and export that to EXCEL?


Thoughts?

 

[TJPoorman]

Not sure how this would work with a subform, but I had a database that used this function to export the current form contents to Excel:

Application.RunCommand acCmdExportExcel

 

[accessNator]

Not sure how this would work with a subform, but I had a database that used this function to export the current form contents to Excel:

Application.RunCommand acCmdExportExcel

Thanks for your reply, but I am not sure how to use this.

 

[TJPoorman]

You would put this in a command button or something to trigger the export.

 

[accessNator]

You would put this in a command button or something to trigger the export.

Oh I see. I see what it does. Not what I was actually looking for on my solution.
Thanks for your reply back.