Help with hyperlinking

[systematic]

Hi all,

Just looking for a bit of help with hyperlinking on a form. Basically, I am adding a 'read more' function to a quiz program I am writing.

I have a label simply called 'Read More' that sits on the form. I need to set a hyperlink to this label, that is looked up from the DB as the hyperlink changes each time the form reloads.

From a simplistic view - I have a table "tbllink", with two fields, 'ID' and 'hyperlink'.

I have tried using a simple DLookUP query as the hyperlink, but access does not recognise this as a piece of code and thinks it is the actual address of the link.

=DLookUp("[hyperlink]","tbllink","[ID] = " & [ID])

Just wandering if there is an easy way to work this?

Thanks in advance

 

[Oldsoftboss]

Why not create a popup form with the recordsource set as the "Read More" table (tblLink). This table would hold the "ReadMore" details, rather than the hyperlink path

Then with the 'On Click' event of either the label or a cmdbutton, just call Docmd.OpenForm "PopupFormName",,, "ID = " & Me.ID