I am Preparing a database software in Access 2007, I have prepared a continuous form (Lets say A) which gives me all the entries in my database. I also prepared another form (Lets say B) which uses Form A as Sub-form. The user enters the keyword in Form B and the filtered results are displayed in sub-form. The problem is I want to export this filtered sub-form in Excel. I tried using "DoCmd.Outputto" command. but on using acOutputForm command it gives me either entire form A or Form B, but not the filtered results that I want. acOutputSubform does not exist and also the sub-form does not have any different name. How can I export this file?