title: ms access browse for file and get file name and path
body: <p>I am using ms access and i want to add a button to browse for a file, get the name of the file and its path . i then  want to store the file path and file name in 2 separate variables. The code i have so far is below and at the moment i can browse for a file and get the name of the file only. Can anyone help me add to my code to get the file path and to store both the file name and file path in separate variables.</p>
  
  <pre><code>Private Sub Command7_Click()
  
  Dim f As Object
  
  Set f = Application.FileDialog(3)
  
  f.AllowMultiSelect = True
  
  If f.Show Then
      For i = 1 To f.SelectedItems.Count
          MsgBox Filename(f.SelectedItems(i))
      Next
  End If
  
  End Sub
  
  
  Public Function Filename(ByVal strPath As String) As String
  
  If Right$(strPath, 1) &lt;&gt; "\" And Len(strPath) &gt; 0 Then
      Filename = Filename(Left$(strPath, Len(strPath) - 1)) + Right$(strPath, 1)
  
  End If
  
  End Function
  </code></pre>