Adding a Browse button

[Gavuk]

Hiya all hope you had a good weekend.

I have a form on which i have a list of attachments. in the following format:

File name : xxxxxxx
File Path : xxxxxxx

I want to be able to put a browse button next to the File path txtbox and the results of the browse to be displayed in the file path and thus saved to the database.

Can anyone help please ????????

 

[mp9]

Two options:

1. Add the common dialog control to your form (it should be in your toolbox already)

2. Implement a entirely code-based solution: check out

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

for an article by Access guru Ken Getz on how to do this.

http://www22.brinkster.com/accessory/