How to create a file lookup and select list in access

[goldsmt]

Hello

I'm new to Access development - what I need to do is create a button on a form that opens up the stsndard windows file browse option, allow the user to navigate to and select a file and return that filename and path to a text field in the database

Regards

Tony goldsmith

 

[PHV]

Depending of your version of access you may consider the FileDialog object

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[goldsmt]

Thansk for you help, I've made progress and now return a vriable with the filename and path to a variable which can be displayed in a message box, how do I now write this value to a new record in the table

Regards

TG

 

[PHV]

By assigning the value of the bounded textbox

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244