error in query

[Azhar.iq]

Can someone please find out what is the syntax error in update query

DoCmd.RunSQL ("Update TblPaymentInfo set ([PaymentForVehicle]) = " & txtVehicleRouteCost.Value & " where ([BookingID]) = " & bookID & ";")

runtime error '3144'

 

[pbaldy]

I'd get rid of all the parentheses for starters. What are the data types of the field being set and the field in the criteria?

 

[Azhar.iq]

I'd get rid of all the parentheses for starters. What are the data types of the field being set and the field in the criteria?

Yup, parentheses did it for me.

 

[pbaldy]

Glad it worked for you.