I have an access database with tables linked from oracle.
I have a form with an unbound object frame on it.
I am attempting to insert a word document into this frame through code.
My word documents are stored in a table in Oracle.
I wanted to retrieve the word document from the database using a lookup then insert into the frame.
My frame is named LetterDocument
Here's what I have so far
I think I figured it out?
I need to use a Bound Object Frame and leave it unbound.
Then in code I can use
BoundObjectFrame.Value = DLookup......
It seems to work, hopefully I am approaching it correctly.