syntax problem

[compwizard]

Hi,

I am getting a syntax error saying: too few parameters expected one.

This is the code that i have been trying:

CurrentDb.Execu te "UPDATE tblitem SET IsSelected = True WHERE itemID = '" & cboItemID & "'"

Would anyone know what the problem could be, the field is alphanumeric

[compwizard]

Not to worry, i have resolved this issue....

[NeoPa]

It would be nice to see your solution. It may help others with similar problems in future.

[compwizard]

The problem was,
The field IsSelected in my table was stored as selected only and therefore this error is occuring, also the piece of code "'" is used for alphanumeric fields.

So i finally worked out....Hope this helps

[NeoPa]

It does - thank you.
I guess the ItemID was actually numeric then.

[compwizard]

thats right.......... ............... ..