Bound object frame insert

[Robin Hermanussen via AccessMonster.com]

Hi,

I have some bound object frames in a list in a form. I've added VBA code
that adds a record to this list. Filling in the fields for the new record
is not a problem, except for the bound object frame (which should contain a
Word document).

So I need to insert a document that I've made with a merge (and written to
a .doc file) into this field. The best way would be to insert it directly.
Can this be done?

Alternatively I could use an update query and then requery the form. How
can I insert a word document directly into the database using a query?

Thanks!

RH

 

[Robin Hermanussen via AccessMonster.com]

Some code to clarify this:

With Me.subBrieven.Form.Controls("document")
.SetFocus
.Class = "Word.document"
.SourceDoc = tempFile
.Action = acOLECreateEmbed
End With

If I use ".Action = acOLEInsertObjDlg" it works! But I want it to be
inserted.