<div>
To add a bit to what als wrote above: There is no control in Access to do this. You must use code, as suggested above, to open the FileDialog.<br />
<br />
Note you can also use API calls for this: <a href="http://access.mvps.org/access/api/api0001.htm" rel="ugc">http://access.mvps.org/access/api/api0001.htm</a>
</div>


To add a bit to what als wrote above: There is no control in Access to do this. You must use code, as suggested above, to open the FileDialog.

Note you can also use API calls for this: http://access.mvps.org/access/api/api0001.htm [http://access.mvps.org/access/api/api0001.htm]

<div>
<div class="content wysiwyg-content">
I have a table with an input form where I need to be able to browse/select a PDF file on the local network.<br />
<br />
I know how to do this in VB6 but have never done much work in Access so I am a little lost on what control or direction to take. <br />
<br />
I set the field up as a hyperlink and if I manually input the file path &amp;&nbsp;name, I can double click on the field and it will open the PDF document.<br />
<br />
Now I just need to allow the user to browse/select the file instead of having to input it manually.<br />
<br />
Thanks for any direction you can give me!
</div>
</div>


I have a table with an input form where I need to be able to browse/select a PDF file on the local network.

I know how to do this in VB6 but have never done much work in Access so I am a little lost on what control or direction to take. 

I set the field up as a hyperlink and if I manually input the file path & name, I can double click on the field and it will open the PDF document.

Now I just need to allow the user to browse/select the file instead of having to input it manually.

Thanks for any direction you can give me!

How can I add a browse to file control in Access 2003

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.