User importing of image files

[avarusbrightfyre]

I've created a form and report that can import a scanned image and paste it in an image control on the report, then output that image to a PDF file (we like to store our scanned images as PDF and our scanning software doesn't have PDF support).

Right now, I have it set up with a text box for the file name (which the user has to type in exactly correct) and a drop down box for the file extension (.jpg, .bmp, etc).

What I want is a way for the user to be able to click a button and use the standard windows "open file dialog box" to find the file, select it and import the image into the image control on the report.

So what I'm asking is, is there a way to use the open file dialog box and store the path of whatever file the user selects in a text box? Or better yet, simply pass the file path to the .picture property of the image control box?



PS: I work for the government, which doesn't allow us to install any third party software, so I'm limited to the software I have right now.

[June7]

Google: VBA file browse dialog box
Here is onehttp:
http://www.tek-tips.com/faqs.cfm?fid=4114