SQL Sentence in VB-GOING MAD!!!!

[Blacknight]

I use the following code and get "Syntax error in update statement". I have tried modifying but to no avail, HELP!!!!

If SetI(Index).Value = 1 Then
acn.Execute ("update settings set " & settings.Fields(Index).Name & " =  " & True & "   ")
Else
acn.Execute ("update settings set " & settings.Fields(Index).Name & " =  " & False & "  ")
End If

1.SETI is just an index of checkboxes
2.when it erroed, settings.fields(index).name was the name of the field I wanted to change
3.settings is a table of one line containing 5 fields of boolean fields
4.darn this!!!!