[peyton]

Hi,

I have this variable


when I update the table it gives an error

here is my update code
Code:

str= "UPDATE tblnames SET Name = '" & name & "' WHERE Id ='" & getid & "'"

can someone tell me what’s wrong with it because the name variable has a comma in it

Thanks
Peyton