I have a search form with a subform on it. I want to export the results from the subform to Microsoft excel. The subform is displayed as a datasheet. I am using the DoCmd.OutputTo acOutputForm, "subDepositions2", acFormatXLS command but it is not exporting the data that is displayed in the subform from the search results but the underlying query of the subform. Can anybody help me with this?