datatype mismatch in criterion expression error

[soutie]

Hi guys,

I keep getting a "Data type mismatch in criterion expression" error.
I cant figure out whats wrong, ive googled but still cant seem to find the problem.

Private Sub cmdSave_Click()

    c.Execute ("Update Addresses set buyerbookdate='" & txtBuyerbookdate.Value & "',buyerbooktime='" & txtBuyerbooktime.Value & "',bbratios='" & txtBuyerRatioS.Text & "' where orderno='" & Combo1.Text & "';")
    MsgBox "Records Added Successfully!", vbInformation, "Save"

Exit Sub
ErrHand:
    MsgBox Err.Description, vbCritical, "Error"
End Sub

Any help would be greatly appreciated!
Brian