You don't need the second "set" in your sql declaration, making it:

sql = "update compliance" & _
" set fix_3year_cml = " & "'" & fix3yearcml & "'," & _
" fix_3year_all = " & "'" & fix3yearall & "'" & _
" where tender_id = " & "'" & Tender_id_num & "'"


HTH
Col