I use Access 2007. I made a form to add/edit the Hyperlink of a file on a
shared drive. I am having a difficulty in creating a macro to open the edit
hyperlink window, with the default location, and then the user clicks on
browse for file to go and select his/her file. Can anyone help me.

Ppons,

No, this can't be done with a macro. You will need to use VBA. As a
starting point, have a look at:
http://www.mvps.org/access/api/api0001.htm

--

Steve Schapel, Microsoft Access MVP


"ppons" <(E-Mail Removed)> wrote in message
news:23B19402-C795-4991-BF37-(E-Mail Removed)...
> I use Access 2007. I made a form to add/edit the Hyperlink of a file on a
> shared drive. I am having a difficulty in creating a macro to open the
> edit
> hyperlink window, with the default location, and then the user clicks on
> browse for file to go and select his/her file. Can anyone help me.