Comexception Was Unhandled Type Mismatch

[EdwardH]

Hello All, I 'm having problem with a comException - Type Mismatch error, I have checked the data types in my table which resides in an Ms Access database. A snippet of code is posted below, the line that produces the error is sandwiched in TRY/CATCH statments, if I remove the lines(the line that produces the error and the TRY/CATCH statements the error will move to the next line.


'save the main client complaint information
rstComplaint.Fields("LotNumber").Value = Me.txtLotNumber.Text
rstComplaint.Fields("ClientName").Value = Me.txtClientName.Text
rstComplaint.Fields("LabArea").Value = Me.cboLabArea.Text
Try
rstComplaint.Fields("TakenBy").Value = Me.txtEnteredBy.Text
' the error as displayed inside the .net IDE points to the line above, the catch statement is not executed
Catch ex As Exception
MsgBox(ex.Message)

End Try
rstComplaint.Fields("ComplaintStatus").Value = strComplaintStatus

rstComplaint.Fields("ProjectName").Value = Me.txtProjName.Text

Any help that anyone can provide would be greatly appreciated

[Frinavale]

Hello All, I 'm having problem with a comException - Type Mismatch error, I have checked the data types in my table which resides in an Ms Access database. A snippet of code is posted below, the line that produces the error is sandwiched in TRY/CATCH statments, if I remove the lines(the line that produces the error and the TRY/CATCH statements the error will move to the next line.

...

Hi Edward :)

Could you please past the exact exception message that your getting.

Thanks

-Frinny