Douglas Post
Registered User.
- Local time
- Today, 11:46
- Joined
- Feb 10, 2012
- Messages
- 22
I have a Button that I want to press to open a PDF. The path to the PDF is constructed from a table called[Listings] that contains part of a link in a field called [Property Root Folder] and then add the end part of the link in another table called [Valuations] with the field [Valuation Link]. The two tables have a relationship with the common field[ListingID] The code I wrote does not work...
Code:
Private Sub BPO_Click()
Dim r As Variant
If Dir(Listings![Property Root Folder] & Me![Valuation Link], vbDirectory) "" Then
r = Shell("Explorer.exe " & Listings![Property Root Folder] & Valuations![Valuation Link])
End If
End Sub
Last edited by a moderator: