M
meyerryang
I have two tables that don't directly relate to eachother. I am using a
subform to filter in the records that I want to see. How can I export this
filtered list within the subform to an excel spreadsheet. When I use the
following code, I export the whole underlying table, and not the filtered
section.
DoCmd.OutputTo acOutputForm, "Lookup Subform", acFormatXLS, , True
Can someone point me in the right direction. Thanks in advance.
subform to filter in the records that I want to see. How can I export this
filtered list within the subform to an excel spreadsheet. When I use the
following code, I export the whole underlying table, and not the filtered
section.
DoCmd.OutputTo acOutputForm, "Lookup Subform", acFormatXLS, , True
Can someone point me in the right direction. Thanks in advance.