Browse button on form

[Mansoor Ahmad]

In my database users download certain text files stored in a separate folder on a network drive. I have managed it to work so that by clicking a command button, it prompts with concerned folder location path and you have to type in the exact name of file with extension .txt at the end and it downloads it. But in this case there are always chances of mistyping.

I wonder how can I set it up like a browse button so that user would only click on the relevant file in a folder and it would select it for download in database?

Can anybody help?

 

[AncientOne]

http://www.mvps.org/access/api/api0001.htm

Does this help?

 

[CJBIRKIN]

Hi found this worked like a charm took <1min

follow the hyperlink in Pats reply

Chris

http://www.access-programmers.co.uk/forums/showthread.php?]here

 

[Mansoor Ahmad]

Thanks

Thank you very much guys. I really appreciate.

The links on your replies took me right on the spot. This is what I am looking for. I am not good with VB codes, but am sure I can manage it.

Thanks again.