Instruction end

[Aussiebear]

Does this work for you?

If the values SongNaam, Bank.Value, Deel.Value, and Locatie.Value are all text fields (requiring single quotes around their values in the SQL string), the corrected code should look something like this:

CurrentDb.Execute "UPDATE tblRegister SET SongNaam = '" & SongNaam & "', " & _
    "Bank = '" & Bank.Value & "', " & "Deel ='" & Deel.Value & "', " & "Locatie = '" & Locatie.Value & "'"

However if the values Bank, Deel, or Locatie are numeric fields in the tblRegister table, they should not have single quotes around their values in the SQL string. For example, if Locatie is a number:

CurrentDb.Execute "UPDATE tblRegister SET SongNaam = '" & SongNaam & "', " & _
    "Bank = '" & Bank.Value & "', " & "Deel = '" & Deel.Value & "', " & "Locatie = " & Locatie.Value