litle confuse with msoFileDialogFilePicker

[bee55]

i have a code for browsing to determine location and the code work
with no Error but the problem is that : for example when i choose
D:\bee55\my folder , the text appear in Textbox1 is D:\bee55 only
my folder not included on the text box.
what shall i do with great thanks

Private Sub Browse_Click()
'Requires reference to Microsoft Office 12.0 Object Library.
   Dim fDialog As Office.FileDialog

   'Set up the File Dialog.
   Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
   
With fDialog
      .AllowMultiSelect = False
      .Title = "Select Last to save your report "
      .Show
      Me!Textbox1 = .InitialFileName
   End With

End Sub

 

[mdlueck]

My version is a bit more verbose than your code. I do successfully receive the full filepath\name with my code.

MS Office File Picker Dialog Box Example
http://www.access-programmers.co.uk/forums/showthread.php?t=232292#post1185165