Run-Time Error 3061

[GraeagleBill]

dfltRetID is integer


gblRetID is integer
CurUserID is integer

From Debug, I know that all of the integer values valid and are correct.

CurrentDb.Execute "UPDATE AddrlstUsers SET dfltRetID = " & gblRetID & " WHERE UserID = " & CurUserID

I keep getting the error:


I'm just not seeing the problem.

Thanks,
Bill

[Bob Fitz]

In the UPDATE statement dfltRetID should be the name of a field (column) in the table called "AddrlstUsers"

CurrentDb.Execute "UPDATE AddrlstUsers SET dfltRetID = " & gblRetID & " WHERE UserID = " & CurUserID

[GraeagleBill]

Thanks Bob, field to be updated is dfltRetAddr NOT dfltRetID! My mind was stuck on thinking there was a syntax problem.

Thanks again,
Bill