how do i reference a pdf document in ms access

[Guest]

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?

 

[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)