open ole object

[braindead2]

I have 2 tables one is a table that feeds area information to my treeview control and the other has area information, the index is areaID. In the area table I have an ole object with a link back to a Word document. What I am atttempting to do is when I select the areaID I want it to launch the document referred to in the ole control.
heres what I have
Dim rst as recordset, db as database
set db = currentdb
set rst = db.openrecordset("areatbl",dbOpenDynaset)
rst.findfirst "areaID = " & me.txtareaid 'this is all OK

'heres where I'm lost. I want to launch the ole object in
rst!Maplocation,just like it does when I double click it on the table

rst.close
set db = nothing
Any help would be appreciated I have tried getobject, set focus, active etc. But I'm lost!!! Thanks in advance

 

[braindead2]

I over came this issue by changing the field from an ole object to a hyperlink then followed the link. However I still would like to know how to launch the ole object as described above. Thanks

 

[Kicker]

You may be able to launch the OLE by using the following,

[objectname].action = acOLEActivate

I have used this for embedded objects, but not Word documents. Good luck

 

[braindead2]

Thanks for the response Kicker. I had given up on a response to this. I will give it a try