Unanswered: Error 2465 when trying to send report using SendObject
I have been having a problem with emailing reports using SendObject. Basically, my form has an option group with the options "Preview, Print, & Email". When a report is selected, and executed this Sub is called:
Private Sub DoReport(stDocName As String)
Select Case Me!optMethodSelect
DoCmd.OpenReport stDocName, acViewPreview
DoCmd.OpenReport stDocName, acViewNormal
DoCmd.SendObject acSendReport, stDocName
Straight forward enough, but for some reason one report does not work but only when the email option is selected. You can preview it & print, it works normally. But if Email is selected, she breaks with Error 2465: Access can't find the field Forms in your expression.
What's puzzling me, is how can the exact same report, run with the same data work when previewed and printed, but not with SendObject? Any suggestions? I'm stumped on this one.