G
Guest
I have a filtered subform that's not linked to the main form. The data on the
subform is filtered based on the controls on the main form.
The filtered subform is showing data ok, but the problem is exporting the
filtered data from the subform. I tried OutputTo method, but everytime
exported all the data in its un-filtered list.
Here's what I use on the cmdExport button onclick:
Me.[SpecificDataSearchSubform].Form.FilterOn = True
DoCmd.OutputTo acOutputForm, "SpecificDataSearchSubform", acFormatXLS, , False
How can I export the filtered subform? Any help is very much appreciated.
Thanks in advance.
subform is filtered based on the controls on the main form.
The filtered subform is showing data ok, but the problem is exporting the
filtered data from the subform. I tried OutputTo method, but everytime
exported all the data in its un-filtered list.
Here's what I use on the cmdExport button onclick:
Me.[SpecificDataSearchSubform].Form.FilterOn = True
DoCmd.OutputTo acOutputForm, "SpecificDataSearchSubform", acFormatXLS, , False
How can I export the filtered subform? Any help is very much appreciated.
Thanks in advance.