Stubern syntax error

[GraeagleBill]

CurrentDb.Execute "UPDATE RoomID IN APPENDAGES WHERE (RecID = " & SelectID & " AND RetYear = " & """" & gblRetreatYear & """" & ");"




I"m going blind trying to find the syntax error in the above UPDATE. "RoomID" and "SelectID" are both integer and "gblRetreatYear" is string, as are the corresponding table fields in the table "APPENDAGES". I even assigned the expression to a temp string and viewed the results. Everything looks okay but still the error.

Been a long day, so thanks for any help.
Bill

[GraeagleBill]

Better make that stubborn..........told you it had been a long day.

[June7]

Update with what? There is no SET clause in the SQL statement. RetYear is a text field? The correct syntax is:

"UPDATE APPENDAGES SET RoomID=something WHERE RecID = " & SelectID & " AND RetYear = '" & gblRetreatYear & "';"

[GraeagleBill]

Good grief, yesterday was just "one of those days"!

CurrentDb.Execute "UPDATE APPENDAGES SET RoomID = " & Me.RmsID & " WHERE RecID = " & SelectID & " AND RetYear = '" & gblRetreatYear & "';"

Thanks,
Bill