cant change datatype to hyperlink cause of linked table - how to open link?

[cassi]

I have a linked table with some URL's in it. I need the table to stay linked but i cant get the hyperlinks to work in my form unless I change the datatype in access to hyperlink. I cant change the datatype becuause the table is linked. Any Ideas ? I realise probaly an on-click event but i ama way newbie !

[NeoPa]

You want it, but you know you can't have it, but you want to know how to get it anyway? Strange question. If you want a hyperlink then make it a hyperlink if you can. If you can't then, well, you can't.

[Mihail]

Try to use a temporary table with a field as you need (hyperlink).
Fill this table with hyperlinks from the original table then use this table as record source for your form.

I know: This approach involve a lot of knowledge in Access and in VBA.