Include address details into Hyperlink field

Hi all,

This following code transcribes a hyperlink string into an Access field from a prepopulated array:

Dim db As DAO.Database
Dim rsImport As Recordset
Dim i As Long, j As Long

    Set db = CurrentDb
    Set rsImport = db.OpenRecordset("TblTable", dbOpenDynaset)

    For i = 0 To lngArrayRowCounter - 1
        If Not varStringArray(i, 0) = "" Then
            rsImport.AddNew
	    '...
	    '...
            rsImport![Summary Hyperlink] = varStringArray(i, 3)
            '...
            '...
            rsImport.Update

        End If
    Next i

However, this only imports the string. It's doesn't also update the address details, which means that the hyperlink doesn't work.

So, how do I also include the underlying address details?

Cheers