I have table with 4 field (1) ID (Primary Auto Increment) (2) TDate (3) BillNO (4) Taka (5) Vat and i have a form with text box "txtID", "txtTDate", "txtBillNo", "txtTaka", "txtVat" an a update button. I want to update record through the from with event procedure. i use the following code to update the record but i got an error "runtime error 3464 data type mismatch" Can anyone help me
<code>
CurrentDb.Execute "UPDATE tblTransaction " & _
" SET [TDate] = '" & Me.txtTDate & "'" & _
", [BillNo] = " & Me.txtBillNo & "" & _
", [TotalTaka] = " & Me.txtTotalTaka & "" & _
", [Vat] = '" & Me.txtVat & "'" & _
" WHERE [ID] = ' " & Me.txtID.Tag & " '"
</code>
<code>
CurrentDb.Execute "UPDATE tblTransaction " & _
" SET [TDate] = '" & Me.txtTDate & "'" & _
", [BillNo] = " & Me.txtBillNo & "" & _
", [TotalTaka] = " & Me.txtTotalTaka & "" & _
", [Vat] = '" & Me.txtVat & "'" & _
" WHERE [ID] = ' " & Me.txtID.Tag & " '"
</code>