I have a field in one of my forms where users will be entering hyperlinks. Is there any way to have a command button on the form that will allow users to browse for files (like the insert hyperlink button on the toolbar)? I would like users to be able to scan certain documents in to a specific folder on a shared drive and then link to those files. Do I need to set a hyperlink base? I am using Access 97, btw.

Thanks!

[This message has been edited by LQ (edited 08-23-2001).]

LQ: Someone on this forum knows how to view the code for other programs. I don't. If you could get your eyes on that code, you could duplicate it on the GotFocus part of the hyperlink control.

I think.

While looking for a solution to a different problem, I came across this piece of code that calls up the insert hyperlink dialog box.

DoCmd.RunCommand acCmdInsertHyperlink

One problem solved, just a few dozen more to go!