MS Access 2003 - Hyperlink a field

[BShick5088]

Good morning,

Is it possible to add code to the "On Dbl Click" of a data field to automatically open the Insert-Hyperlink menu?

I have a form that has a field pointing to a table with hyperlink set as a data type. What I want to do is easily be able to have a user enter a hyperlink to a project document on a network drive for future reference. I have it working now, but the user has to know to pick the drop menu INSERT then pick HYPERLINK to open the menu to browse to the document. What I would like to be able to do is when the user double clicks the field have the insert-hyperlink menu automatically open.

I tried the: Application.FileDialog(msoFileDialogOpen).Show

and it gives a run-time error: Method 'FileDialog' of object '_Application' failed.

Is ther something I am not seeing?
Thanks,
Brian


Application.FileDialog(msoFileDialogOpen).Show

 

[kjv1611]

Maybe I missed it, but which application are you working in, and is this a user form with fields, or are the controls on the worksheet/document?