How to Increment an integer field by one using currentdb.execute

[behnam]

CurrentDb.Execute "UPDATE TimeHandle SET [counter] = [counter] +1 WHERE [agent] = " & gsUser

the code above is suppose to increment a counter in the table Timehandle by 1 wherever the agent field is equal to the value stored in a global variable called gsUser. Does anyone know what is wrong with the syntax, thanks.

[JoeM]

Is Agent a string or numeric field?
If it is a string (text), you need text qualifiers (of single quotes), i.e.

CurrentDb.Execute "UPDATE TimeHandle SET [counter] = [counter] +1 WHERE [agent] = '" & gsUser & "'"

[behnam]

Thanks, worked perfectly.