Have a dialog box link a file loction to a textbox

[BZeyger]

Hello,

I have a form which refers to a table.
The table has a row named location which is a hyperlink.
The form is in a datasheet view. I would like to set an on-click command to
display a dialog box to refer to a specific file loction. Once the user
selects a file to link to, that location should appear in the selected
txtlocation field (which is linked to the data Table)

 

[schasteen]

Look at http://www.mvps.org/access/api/api0001.htm for the open/save dialog
box. You can use this to let the user select the file they wish to link to
and then save it to your hyperlink field