double click list box to open hypertext linked document

[b_c]

this question was embedded in another post under a different title...not trying to double post, just wanted to clear up this problem i'm having though:


I've got cascading list boxes:

OrgNameList and SpecNameList

when OrgNameList updates, it populates the SpecNameList from information in a table "SpecTable" which has columns for ID (autonumber), OrgName, SpecName, and SpecLink (hypertext link to pdf file).

I used:

Private Sub OrgNameList_AfterUpdate()
   On Error Resume Next
   SpecNameList.RowSource = "Select SpecTable.SpecName " & _
            "FROM SpecTable " & _
            "WHERE SpecTable.OrgName = '" & OrgNameList.Value & "' " & _
            "ORDER BY SpecTable.SpecName;"

End Sub

for cascading the lists, but now i'd like to be able to double click a SpecName in the SpecNameList and open up it's respective PDF file. Can anyone help?


thanks,

b_c

 

[Pat Hartman]

In the double-click event, use the follow hyperlink method:

Application.FollowHyperlink Me.ThisFieldName, , True