Code:
sSQL = sSQL & "VALUES (" & Me.cboAllcall.column(1) & "," & mid & " ," & me.txtcalldate & " );"
What is "mid"?? Be aware that "mid" is a reserved word (and a built-in function) and shouldn't be used as an object name.
When working with dates, the dates MUST be in USA format (MM\DD\YYYY)
See Allen Browne's site http://allenbrowne.com/ser-30.html
Scroll down to Dates in Strings
If you add the function SQLDate, the SQL would look something like
Code:
sSQL = sSQL & "VALUES (" & Me.cboAllcall.column(1) & "," & mid & " ," & SQLDate(me.txtcalldate) & " );"
Note: the function "SQLDate" adds the date delimiters, so you don't need to add them.