problem emailing report with subform

[Guest]

I have an order confirmation that is emailed after the order is entered. I
just added a subform to the Confirmation Report. When I try to send it I get
this message: "The save as command can't process any subforms contained in
your report". This the code I use to send the email:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.SendObject acReport, "rptOrderConfirmation",
"RichTextFormat(*.rtf)", Forms!Orders!Email, "", "", "Order Confirmation",
"Message" I don't have a clue what the problem is.
Thanks for any help on this.
Ron

 

[Rick Brandt]

I have an order confirmation that is emailed after the order is
entered. I just added a subform to the Confirmation Report. When I
try to send it I get this message: "The save as command can't process
any subforms contained in your report". This the code I use to send
the email:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.SendObject acReport, "rptOrderConfirmation",
"RichTextFormat(*.rtf)", Forms!Orders!Email, "", "", "Order
Confirmation", "Message" I don't have a clue what the problem is.
Thanks for any help on this.
Ron

A report should use a subreport, not a subform. Access will let you embed as
subform in a report, but as you have seen not everything works when you do that.

 

[Guest]

Thanks Rick

Sometimes MS don't make it clear.
Ron

 

[Guest]

OOOPS!

I just created the subreport using the subreport wizard, and got the same
message.

 

[Guest]

I found my answer. All I had to do was open my subform in design mode and do
a Save As> Report. Then I dragged it into my main report . It works fine now.

Thanks
Ron