Dialog Boxes

[Richard Smith]

Is it possible to have an on click function on a text box that opens a
dialoge box, the dialog box would allow the user to select a file name i.e.
browse and then store the file name and path in a field

Richard

 

[HSalim]

Here is Dirk Goldar's reply to Browse for Local Files in this NG
------------

In Access 2002 or later, you can use the Application.FileDialog object
to do this. For earlier versions, I'd recommend calling the Windows
File Open/Save API directly, using code that you can find here:

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