So do as I suggested with a string variable and paste the results of that back here.
Or better still construct is a lot better? 
CurrentDb.Execute "Update tblRegister Set SongNaam = '" & SongNaam & "'" &  _
    ",Bank = '" & Bank.Value & "',Deel = '" & Deel.Value & "',Locatie = '" & Locatie.Value "'"