braindead2
Technical User
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
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