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