Create Hyperlink with a twist

[jerseyboy]

I want use a hyperlink on a data field to open a link...
The issue is I want to qualify the way the link opens with a choice of new record or open to view the existing records.

To do this I set up a message box that offers the choice with a YES/NO/CANCEL option for the user.
If the user presses YES then the form opens to the appropriate choice.

Here is the problem: By placing the code in VB for the 'simulated hyperlink' I loose the ability to display the customary hand pointer that people associate with hyperlinks. Is there a way around this?
I could make the link into a text box and lock the default value then change it's property to hyperlink and so on, but that is not the way I would like to handle this.

Any Suggestions?

Thanks for your help
JerseyBoy
Remember: self-praise is no recommendation

 

[jerseyboy]

Although it isn't pretty, I think this is an acceptable way for me to work through my problem...

I placed a "#" in the hyperlink properties box (# = refresh the page) and it worked...just remember to change the control tip text so that the user sees something other then "#" when they pass the over the hyperlink JerseyBoy
Remember: self-praise is no recommendation