Get and Store the Full Path of a File on the Computer

[MichaelA]

I'm sorry if this has been asked before. I have a text box that I want to store the full path of an image file in. And I have an image control that will show the image file whose path is set in the text box. I have all of that and it works. What I want is a button, that when pressed will open the windows explorer so a user can navigate to the image file, and when the correct image is selected the full path to it will be stored in the text box. To clarify, the text box, itself, will be empty on a new record. The button, next to the text box, will allow what I described.

Thank you for your help. You folks have been great.

[kd2017]

Research 'vba filedialog'. I used this code the other day:
https://docs.microsoft.com/en-us/off...ion.filedialog

Sounds like you'll want to set multiselect to false.

[MichaelA]

Research 'vba filedialog'. I used this code the other day:
https://docs.microsoft.com/en-us/off...ion.filedialog

Sounds like you'll want to set multiselect to false.

I get a compile error that says, "user defined type not defined." And the debugger is on "Dim fDialog As Office.FileDialog"

Thank you!

[Micron]

The message usually means you are missing a reference. For that, I believe the reference is the latest Office library you'd have on your pc. Check references in the vb editor.

[MichaelA]

The message usually means you are missing a reference. For that, I believe the reference is the latest Office library you'd have on your pc. Check references in the vb editor.

Yes! Success! It is working now.

Thank you, so much!

[Micron]

Great! Glad to see we solved it. Remember the error message for next time