Please Help, I am trying to use a list box populated by a query to change the object in an unbound list box using the onclick event. History: I established an unbound object frame and put a clip of a word document in it and displayed on a form. I then created a list box and tried to create an on click event to change the object in the frame to a new word document (I’m sort of using this as a document preview situation). However no matter what I try I can’t get it to work. I looked at the help text and it described a way of linking but if I follow that method exactly it still will not work. I would appreciate any thoughts on this.
I tried this code based on previous thread suggestions within this forum:
” With Me.objFrmContractReviewPreview
.CLASS = “Microsoft.Word”
.SourceDoc = “W:DEPT400410SHAREContractReviewEDAN00024-00-C-2103 P00016.doc”
.Action = acOLECreateEmbed ‘ or acOLECreateLink
End With”
and get this:
“Run Time Error 2793
Microsoft Office Access can’t perform the operation specified in the action property of the visual basic procedure youre trying to run.”
Thanks
Kevin