how do i reference a pdf document in ms access

B

barnwood

I want to create a list of pdf documents using a listbox and then by
double-clicking a row in the listbox access will open the appropriate pdf
document, any ideas?
 
D

Douglas J. Steele

Assuming your list box is set to Single select only, you can use:

Application.FollowHyperlink Me.MyListbox

(replace MyListbox with the actual name of your list box)

If it's set for Multiselect, try:

Dim varSelected As Variant

For Each varSelected In Me.MyListbox.ItemsSelected
Application.FollowHyperlink Me.MyListbox.ItemData(varSelected)
Next varSelected

(for that matter, you can use the second approach even if it is set to
single select)
 
Top