Subforms to Excel

D

devine

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?
 
E

Eric Blitzer

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