Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't find field 'Forms' referred to in your expression

Status
Not open for further replies.

theConjurian

IS-IT--Management
May 4, 2002
35
CA
DoCmd.OpenReport "Booking Information", acViewPreview, wherecondition:=strWhereCond

DoCmd.SendObject acSendReport, "Booking Information", acFormatHTML, strAddress, , , _
"Booking Information", strMessage, True

DoCmd.Close acReport, "Booking Information"

In the code fragment above, the message
"Can't find the field 'Forms' referred to in your expression"
comes up as it executes the SendObject statement. This stopped working when I changed a graphics element in the report (which is why I changed it in the first place!)

Can anyone suggest why this might be happening?

On a related note, the graphical element gets stripped out of the email version of the report. What can I do to get it to appear? Someone suggested that it had something to do with the conversion to Windows Metafile prior to sending.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top