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!!!!

[leinad31]

Are there spaces in the field names? You'll needto enclose in [] brackets for an access database if so.

BTW, is that ADO or DAO?

[Blacknight]

There are no spaces in the name. the name is language. I am using ADO.

[Blacknight]

could that be a saved name?

[Blacknight]

Yep, thats the problem. It suddenly donned on me that it error on a specific index which wasn't even called, which led me to believe it was a saved name.

[Blacknight]

Thank god, I was just about to bang my head very hard on the wall.