Linking a different table hyperlink to each form record

[mstanley71]

Hi All,

I have a problem, I'm using Access 2002 SP3. and am trying to use a
button on each form to link back to a hyperlink on a table based on a
combo box selection on the same form record..ie SELECT NNI_DRAWING FROM
NNI1 WHERE NNI_CKT_ID=FORMS!PVC!NNI_USED;.

I'm able to do this using a combo box to show the hyperlink
(NNI_DRAWING). The problem is that this:

Forces the user to click in the combo box to show the link, and click
ont the link again to activate it.

Allows the user to modify the link

I'd like to have a simple button that the user can click that would
open the hyperlink based on the SELECT NNI_DRAWING FROM NNI1 WHERE
NNI_CKT_ID=FORMS!PVC!NNI_USED;. statement.

Any help is appreciated.

Thanks,
Mark