Subforms to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Back
Top