Path definition

Hi.
I need to ask the user in a customised menu something like: 'Settings
Documents folder location', where the user would define a [path] to a folder.
Then I would use that path in the following code:

Private Sub ID_Ordem_DblClick(Cancel As Integer)
Dim nome As String
nome = Forms!frm_Obras!Doc_nome
Application.FollowHyperlink path & nome & ".doc"
End Sub

How can I do this?
Thank you in advance.

If I were doing this, I'd use the BrowseFolder API at accessweb.
www.mvps.org/access

It's in the APIs section.

Thank you for your answer.
But, it is possible to chose the path only once and predefine it in order to
avoid the user to select the folder every time he wants to open a file?
Thank you again.


" escreveu:

If I were doing this, I'd use the BrowseFolder API at accessweb.
www.mvps.org/access

It's in the APIs section.

Sure. Save it in a global variable once it's been selected.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"acores" wrote in message
...
Thank you for your answer.
But, it is possible to chose the path only once and predefine it in order
to
avoid the user to select the folder every time he wants to open a file?
Thank you again.


" escreveu:

If I were doing this, I'd use the BrowseFolder API at accessweb.
www.mvps.org/access

It's in the APIs section.