Saving Hyperlink Into Record Of Database

I have to save the hyperlink of the copied file into a record of my database.

Private Sub Knop29_Click()
Pad = "C:"
Dim Bestandslocatie As String
Bestandslocatie = DLookup("[Waarde]", "tblInstellingen", "[Tag] = 'Locatie'")
With Application.FileDialog(3)
.Title = "Bestand selecteren"

[Code] .....

The column where the hyperlink of the copied file has to come is "data".

As you can read the code i tried to do it this way: Me.Data.Value = NewName, but then i only get this pad saved into my database:

hns019afdelingafd_tdHasseltOpslag documentatie TDMaxihalKranenKraan24TraverseSoftware

So i need to find a way to past the file name after this link so that it becomes something like this:

hns019afdelingafd_tdHasseltOpslag documentatie TDMaxihalKranenKraan24TraverseSoftwareFile.exe