Ive given a button the action:

Private Sub Command49_Click()
ActiveXCtl48.ShowOpen

MsgBox "Filename: " & _
ActiveXCtl48.FileTitle
MsgBox "Path: " & Left$(ActiveXCtl48.FileName, _
Len(ActiveXCtl48.FileName) - Len(ActiveXCtl48.FileTitle))

MsgBox "Filename: " & _
ActiveXCtl48.FileName
End Sub

which works perfectly fine (the msgbox's are just for verification)

I have a text box called "txtDocPath". When the user chooses the file after clicking the button, I want this text box to be updated with the path and filename (with extension) of the chosen file.

Any help will be greatly appreciated.

Regards
Paul

BTW this is in msaccess 97.