Subforms to Excel

[Guest]

I have a form in my database that includes two subforms. The two subforms
run off of seperate queries. The main form looks and acts exactly as I
expect. My challenge is getting the form to output to Excel.

I've done this successfully before, but never with a form that includes a
subform (let alone 2 subforms).

The "on click" programming I've used is this:
DoCmd.OutputTo acOutputForm, Form1, acFormatXLS, , True

And it outputs beautifully, but it doesn't work when I have a form with a
subform.

Any suggestions?

 

[Guest]

You don't export forms to Excel. Create a query specifying the data from the
form.