Update multiple columns using docmd.sql "Update" command

Dear Friends,
Am trying to update multiple columns in a customer table but the statement am using is returning an error. Kindly check it for me.

DoCmd.RunSQL ("update customer set customer.paid=" & Me.Parent.txtPAID.Value,customer.balance = me.Parent.txtcontract.value+me.Parent.txtpaid.valu e)

Thanks,
Njoroge Joseph:banghead::banghead:

Update multiple columns using docmd.sql "Update" command