Error in Updateing my table

[nkechifesie]

I am trying to update my tables, and this error occurs
Runtime error '-2147217900 (80040e14)':syntax error in update statement only for the table Action types.This is the code
and where error occurs is in Bold

If frmAdd.Caption = " CITY " Then
        StrSql = "UPDATE City SET CITY = '" & Text1.Text & "' WHERE CITY _
         = '" & OldVal & "'"
        CnEdit.Execute StrSql
ElseIf frmAdd.Caption = " TYPE OF ACTION " Then
        StrSql = "UPDATE ActionTypes SET Action = '" & Text1.Text & "' _
        WHERE Action = '" & OldVal & "'"
        CnEdit.Execute StrSql
ElseIf frmAdd.Caption = " RNE NAME " Then
        StrSql = "UPDATE RNE_names SET RNEName = '" & Text1.Text & "' _
        WHERE RNEName = '" & OldVal & "'"
        CnEdit.Execute StrSql
    End If
 

please not that all parameters have been set and the error doesnt occur when the caption is City or RNE Names.
Thank you.

[willakawill]

Hi. If you have pasted your code here the answer is easy enough.

StrSql = "UPDATE ActionTypes SET Action = '" & Text1.Text & "' _
        WHERE Action = '" & OldVal & "'"

is missing quote marks

StrSql = "UPDATE ActionTypes SET Action = '" & Text1.Text & "'" _
        & " WHERE Action = '" & OldVal & "'"

This is on all 3 of your sql statements

[Killer42]

Hi. If you have pasted your code here the answer is easy enough.

StrSql = "UPDATE ActionTypes SET Action = '" & Text1.Text & "' _
        WHERE Action = '" & OldVal & "'"

is missing quote marks ...

But how would that have made it past syntax check?

[willakawill]

But how would that have made it past syntax check?

We have to start somewhere. How could we get any further than obvious typos if we don't get them straight first?

[Killer42]

We have to start somewhere. How could we get any further than obvious typos if we don't get them straight first?

Excellent point. Just wondered whether I've missed some "continue with errors" option or something.

[Killer42]

I've got it! Bet you $5 that Action is numeric. :)

[nkechifesie]

RESOLVED
Thanks for all your help. I discovered Action as a reserved word in VB, changed the column name and now it works.

[Killer42]

RESOLVED
Thanks for all your help. I discovered Action as a reserved word in VB, changed the column name and now it works.

Rats! There goes my 5 bucks.

Glad to hear you've resolved the problem, though. :D