hi all..
I have a program that save Employee data into Access DB

After i save a data and i want to update the data...the error message "Data type mismatch in criteria expression"..will be displayed.

can someone tell me what should i do or change with my coding below.....

badgeno---Numeric
name,grade,project,area,remarks-----Text
doj-------Datetime
camp,monthly(checkboxes)-----text

" update emp set badgeno='" & txtbadgeno.Text & "',name= '" & txtname.Text & "',grade= '" & txtgrade.Text & "', project='" & txtproject.Text & "',area='" & txtarea.Text & "',doj='" & txtdoj.Text & "',camp='" & Check1.Value & "',monthly='" & Check2.Value & "',remarks= '" & txtremarks.Text & "' where badgeno= '" & txtbadgeno.Text & "'"