G
Guest
I have a form that allows the users to select criteria that is then displayed
in a subform. The user needs to be able to export the filtered (requeried)
resultset to EXCEL.
I have used the following code, but it exports all the records instead of
just a few. What is the correct way to do this?
'export the results to Excel
DoCmd.OutputTo acOutputForm, "subfrmData", acFormatXLS, "1.xls", True
in a subform. The user needs to be able to export the filtered (requeried)
resultset to EXCEL.
I have used the following code, but it exports all the records instead of
just a few. What is the correct way to do this?
'export the results to Excel
DoCmd.OutputTo acOutputForm, "subfrmData", acFormatXLS, "1.xls", True