Get path and file name

[Robin]

I would like to set a path and file name in a text box by
clicking on the name of a file in a list of directories
and files as is seen when using 'Open file' or in
Microsoft Explorer.

How can I get the list and how can I transfer the path and
file name to the text box? Thank you.

 

[Dirk Goldgar]

I would like to set a path and file name in a text box by
clicking on the name of a file in a list of directories
and files as is seen when using 'Open file' or in
Microsoft Explorer.

How can I get the list and how can I transfer the path and
file name to the text box? Thank you.

There are various ways to do this, but the most reliable is to call the
Windows API directly to display the "Open File" dialog. Code for that,
with an example, is posted here:

www.mvps.org/access/api/api0001.htm