Hyperlink and dialog box

[sci]

Can anyone help with this...
I want double click on a hyperlink address box to open the dialog File open,
so that clicking the filename in the file open dialog will put the filename
in the hyperlink address box. Is this poss? if so, what is the simplest way
to do so?

Cheers!

 

[storrboy]

Can anyone help with this...
I want double click on a hyperlink address box to open the dialog File open,
so that clicking the filename in the file open dialog will put the filename
in the hyperlink address box. Is this poss? if so, what is the simplest way
to do so?

Cheers!

Simplest would be to use a button beside the textbox instead. Having
the text box as a HyperLink field will likely try to launch whatever
file or address is contained in it - before you can run code to browse
for a file. The button would allow you to separate the two functions.

If you are asking how to browse for a file, there is an example at
http://www.mvps.org/access/api/api0001.htm