Exit from imbedded message without updating

[nschroeder]

I have a field called NoteMsg with a datatype of OLE Object. On the form, the field appears in a Bound Object Frame. MS Outlook messages are copied and pasted into the field to provide supervisor approval for projects. On the form where the messages can be opened and read, the Allow Edits, Allow Additions, and Allow Deletions properties are set to No. When you open the message to read it, then close the message and attempt to close the form, you get "Can't save your changes to this bound OLE object." When you click OK, you get "You can't save this record at this time ... If you close this object now, the data changes will be lost. Do you want to close the database object anyway? [Yes] [No]".

The message hasn't been updated, but it thinks it has. How and where would I tell it that the record was not updated and avoid the warning messages? I put msgboxes in various events, but the only one that gets triggered is the Updated event (it fires 3 times for some reason), but I can't find any help or documentation on what the Updated event even is.

Any suggestions?

 

[vbaInet]

How are the messages copied and pasted?

 

[nschroeder]

To copy an Outlook message into an OLE Object field, you have to first copy & paste it to the desktop, then copy it from the desktop and paste it into the database field. No other way around it that I've found.