Having trouble using an UPDATE command

[database_1]

I am attempting to change a ID in a table from a value taken from a form. I was able to turn both the original ID and the new ID into variables. These output values have been checked using a message box. I then have the code, CurrentDb.Execute "UPDATE [TRNG_MNGM] SET [TRNG_ID] = new_id WHERE [TRNG_ID] = old_id". By doing this, I get a run-time error 3061. It says there are too few parameters, expected 2. I have tried trouble shooting a couple different things but nothing has worked. If anyone could point me in the right direction, it would be greatly appreciated.

[CJ_London]

try

CurrentDb.Execute "UPDATE [TRNG_MNGM] SET [TRNG_ID] = " & new_id & " WHERE [TRNG_ID] = " & old_id