[Tswakza]

Hi there,

I am trying to update MS-Access database where one field is boolean and updating a string. I am getting a error message "Conversion from string "Update Claims set appointed=" to type double is not valid". HOW DO i RESOLVE THIS ERROR

[June7]

Please show the complete UPDATE query with the update value/variable reference. And clarify what you want to do, your description is confusing. You want to update a string field with Boolean? Or are you updating Boolean with a string? The error message indicates attempt to update a numeric field failed (is Boolean datatype field treated as double?). Is the update value coming from control on form?