Access2K – Browse to return Path

I have a common dialog box control on a form in Access 2000. There are two visible controls on the form: a command button named ‘cmdBrowse’ and a text box control named ‘txtPATH’.

I want to browse for a file, select it, and have ONLY the PATH to the file returned to the text box control on the same form.

I do not want to open the file, I only want to bring back the PATH as the value in the ‘txtPATH’.

For example: after selection, the returned value in ‘txtPATH’ would be: ‘C:\MyDocuments\Project\Xyx.doc’

Any help will be appreciated. Thanks.

Rich