Browse-function from a button (1 Viewer)

[Thomas]

I want to make a button with BROWSE-function for finding a file, and have the whole path to the file reportet back into the database.
Is there any function for doing this?
(e.g:
Name of Picture: "Mona Lisa"
Located: [browse] "c:\pictures\monalisa.jpg"

Thomas@greig

 

[simmerscol]

I did something simular to that by using Query by Form. It works great. I did mine through SQL. On the microsoft help for access 97 there is a good explaination of QBF.

You make the button and the SQL behind the scenes will work it all for you.