Put it into a string variable and debug.print it
Awful structure TBH.

But as a guess
CurrentDb.Execute "Update tblRegister Set SongNaam = '" & SongNaam & _

  "',Bank = '" & Bank.Value & _
  "',Deel = '" & Deel.Value & _
  "',Locatie = '" & Locatie.Value "'"