exporting forms with a subform

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hi. I already posted this, but I wanted a better answer
than "Micsoft Access does not export subforms."

I have made a form that has "item" information at
the top, and it has two subforms underneath it which
contain detail information from a few different sources.

Now my task is to export this form into an emailable
form. Exporting into Excel definitely does not work.
I've tried outputting my form "Form1" into html, but only
Form1 is exported. The two subforms are not.

Does anyone have a workaround to this limitation of
Access?

Any ideas?

Thanks,
Joe
..
 
I found a little blurb on the MS site about why subforms
don't get exported with the form. It said very bluntly
that subforms do not get exported. I'm trying to find
the link.
 
Hi Lynn. Here is what I found on MS's site:
_____________________________________________
http://office.microsoft.com/assistance/preview.aspx?
AssetID=HP030851161033&CTT=4&Origin=CH063648341033
Export the subform separately.<<
_____________________________________________


Exporting forms into Excel results in exporting the
database, so I'm exporting the form into HTML (I only
need to send the file electronically). Problem is I
can't link the forms back together if I export them
separately.
 
Ah, now I understand better. What you have to remember is that a subform is
actually a form in its own right. It is merely displayed on a main form
using a subform control. The subform control IS exported with the main form,
but it is of no use without the actual form that is displayed in that
subform control.
 
Back
Top