Private Sub Load_HyperlinkBTN_Click()
   Const msoFileDialogFolderPicker As Long = 4
   Dim fd As Object
'Create a FileDialog object as a File Picker dialog box.
   Set fd = Application.FileDialog(msoFileDialogFolderPicker)
'Use a With...End With block to reference the FileDialog object.
   With fd
'Set the initial path to the D:\Documents\ folder.
  ' InitialFileName = "\\ap1\tools\db\"
   .Title = "Select Attachment"
'Use the Show method to display the File Picker dialog box and return the user's action.
'If the user presses the action button...
   If .Show = -1 Then
'   DoCmd.GoToRecord , "", acNewRec
    Me![Charactisation results_PL Reports] = "#" & .SelectedItems(1) & "#"
'  **
'If the user presses Cancel...
   Else
   End If
 End With
'Set the object variable to Nothing.
   Set fd = Nothing
End Sub