Hello,

My vba code reports to me “expect instruction end”


CurrentDb.Execute "Update tblRegister Set SongNaam = '" & SongNaam & _

  "',Bank = '" & Bank.Value & _
  "',Deel = '" & Deel.Value & _
  "Locatie" = Locatie.Value "", ;
the last line gives the error.

Any help would be appreciated.

TonC