I have two sets of two buttons on a form:
(1)The first set has a Pick button that opens a dialog window where  to choose and save the path to a field 'FolderLocation' The Associated button is to open a dialog window to that fold where I am able choose a file to open.

Details

Private Sub FilePathBtn_Click()
On Error GoTo Err_FilePathBtn_Click
With Application.FileDialog(msoFileDialogFilePicker)
.Show
Me!FolderLocation = .SelectedItems(1)
End With
Exit_FilePathBtn_Click:
Exit Sub
Err_FilePathBtn_Click:
MsgBox Err.Description
Resume Exit_FilePathBtn_Click
End Sub
Private Sub OpenFolderBtn_Click()
Application.FollowHyperlink Me.FolderLocation
End Sub

(2)The second set has a pick button that a dialog window where  to choose and save the path to a field 'LocationFilePath'  The associated button is open that specific file (usually a PDF).

Details

Private Sub OpenFolderBtn_Click()
On Error GoTo Err_OpenFolderBtn_Click:
Application.FollowHyperlink Me.FolderLocation
Exit_OpenFolderBtn_Click:
Exit Sub
Err_OpenFolderBtn_Click:
MsgBox Err.Description
Resume Exit_OpenFolderBtn_Click
End Sub
Private Sub OpenFileBtn_Click()
Application.FollowHyperlink Me.LocationFilePath
End Sub

The difference is that one set pick the opens folder path, the set pick pat and opens' a specific file.
All Four have common problem: If I cancel the dialog widow (rather than 'OK') it error's out 'The expression you entered has an invalid reference to the Parent property' but doesn't cause a debug error. Otherwise (1) work correctly.
(2) The an associated, 'Pick' button is to open a file from a folder, that I choose and saved in a field 'LocationFilePath'; it works accept for the cancel thing. The other button is supposed Open the specific file but error's out. The 'Error is '90' (cannot open the specified file)'.
Am using the wrong approach