I had to add in an UpdatePicture before the Exit Sub if you choose not to Overwrite, otherwise the form wasn't updated. The code I have for it now is the following. I'm interested if anyone sees any issues with it or a way of improving it.

Details

Private Sub EmployeePictureBtn_Click()
    
    Dim PathFilename As String
    Dim FilenameOnly As String
    Dim L As Integer
        
    L = Len(ImagesFolder)                   'C:\Users\djemc\OneDrive\... \Images\  129
    PathFilename = PickFile(ImagesFolder)   'C:\Users\djemc\... \Downloads\rick1.jpg
    FilenameOnly = GetFilenameOnly(PathFilename)    'rick1.jpg
    EmployeePicture = FilenameOnly
    
    ' Check and see if we're in the images folder already
    If Left(PathFilename, L) <> ImagesFolder Then
        ' I'm NOT in the images folder, copy the file
        FilenameOnly = EmployeeID & "-" & FilenameOnly  '1-rick1.jpg
        If Dir(ImagesFolder & FilenameOnly) <> "" Then
            ' The file already exists, ask to overwrite.
            If MsgBox("File already exists. Overwrite it?", vbYesNo) = vbNo Then
                UpdatePicture
                Exit Sub
            End If
        End If
        FileCopy PathFilename, ImagesFolder & FilenameOnly
    End If
        
    EmployeePicture = FilenameOnly
    UpdatePicture

End Sub