E-Mailing a report with subforms

[Guest]

Hi! I'm trying to use the SendObject command to e-mail a report with
subforms. I've tried both Snapshot and Rich Text Format and get the message
"The Save As command can't process any subforms contained in your report."

Does anyone have any suggestions either to resolve this error ... or another
way to accomplish my goal?

Thanks!

 

[Guest]

Open your subform in design mode and "save as" a report. Insert this report
into the report you are trying to e-mail as a subreport. You may have some
minor formating changes required after saving the form as a report. You will
have to associate the subreport to the report the same way you associate a
sub form to it's parent.

Since a form is a "window" into whatever record source you are looking at,
you cannot email this "window".

By associating this subreport to a new query with the information you want,
you can insert criteria into the query to call up the same records current in
the form you are using.

 

[Guest]

That worked great, Jeff ... thanks!
And thanks for the warning about potential format problems. I probably
would not have noticed until some "ugly" stuff went out.
Thanks again!
Cindy