Extract subform into excel

[Joy83]

Hi all,
I have two subforms in one main form
Once you click on a field in subform1 it filters the results in subform2
I want to extract the resulted data in subform 2 in excel as is (as showing in the form)

i tried many things but it didn’t work. Can you plz help

 

[theDBguy]

Hi. Have you tried using the CopyFromRecordset method?

 

[Joy83]

thanks for your reply
Can you refer me to a link I didn’t try this method
I was trying transferspreadsheet and outputto

 

[Gasman]

thanks for your reply
Can you refer me to a link I didn’t try this method
I was trying transferspreadsheet and outputto

Here are a few
https://www.google.com/search?q=Cop...5i39j0i512l8.958j0j4&sourceid=chrome&ie=UTF-8

 

[Joy83]

This line is working fine except it brings all the subform (not the filtered one)
What to put instead “?” To make it transfer only the filtered data in the subform
DoCmd. Outputto ac outputform, ? , acformatxlsx

 

[arnelgp]

here is a demo.
if you need to adopt to your db, copy the 3 modules.

 

[Pat Hartman]

Use a query to export the data. In the query, use a WHERE clause that references the first subform.

WHERE SomeField = Forms!yourmainform!yourfirstsubform!SomeField