Good morning everybody:
I have some VBA code that I copied from Rick's sample database.  It's for a file picker and it works great.  I'm looking to add some more code to it so that when the file is picked, it is copied to a share on the network and the path is stored in the database.  Here's the code I'm using:

Code below...

Private Sub FilePickerBtN_Click()
StoredPath = PickFile("\\WIN-SERVER-001\Attachments")
End Sub
Public Function PickFile(Optional InitialFolder As String = "", _
        Optional IsFolder As Boolean = False, _
        Optional FilenameOnly As Boolean = False) As String

    Dim FO As Object, FSO As Object, PickType As Long
    
    On Error Resume Next
    PickType = IIf(IsFolder, 4, 3)
    Set FO = Application.FileDialog(PickType)
    If InitialFolder <> "" Then
        FO.InitialFileName = InitialFolder
    Else
        FO.InitialFileName = CurrentProject.Path
    End If
    FO.Show
    PickFile = FO.SelectedItems(1)
    
    If FilenameOnly Then
        Set FSO = CreateObject("Scripting.FileSystemObject")
        PickFile = FSO.GetFileName(PickFile)
    End If
End Function

Private Sub StoredPath_DblClick(Cancel As Integer)
ShellExec StoredPath
End Sub

I'm brand new to coding.  What I've learned is mainly from Rick's videos and things I've found on the web.  Thank you all for understanding.  Have a wonderful day.