Browse to a File and Save Path in a Text Field

[PSSMargaret]

The below code works great to capture the path and file name of a file and put it in the text box, however, it doesn't retain the data. When I return to the form, the path to the file is gone. What is the below missing in order to save the data in the text box?

Private Sub Command12_Click()    
    Dim dialog As FileDialog
    Set dialog = Application.FileDialog(msoFileDialogFilePicker)


With dialog
    .AllowMultiSelect = False
    .Show
Me.Text13 = .SelectedItems.Item(1)


    End With
End Sub

[ranman256]

the textbox MUST be bound to a table field.

[PSSMargaret]

Thanks so much Ranman256. Makes perfect sense. I was experimenting in a form only without the text box bound to a table field.