This it the sql statment
sqlTemp = "INSERT INTO tCallLog (IndexNumber, LoggedBy, ForConsultant, Client, Person, Timelogged, DateLogged, Notes, Urgent, Priority, WasRespondedTo) VALUES ( MAX('IndexNumber') + 1, '" & CurrentUser.username & "', '" & cmbConsultant.Text & "', '" & txtClient.Text & "', '" & txtPerson.Text & "', '" & txtTimeLogged.Text & "', '" & Format(Now, "dd/mm/yyyy") & "' , '" & Chr(35) & txtNotes.Text & Chr(35) & "', " & chkUrgent.Value & ", '" & cmbPriority.ListIndex & "', " & chkWasRespondedTo.Value & " );"

ok ... table:
IndexNumber int
LoggedBy char
ForConsultant char
Client varchar
Person varchar
TimeLogged text
DateLogged text
Notes text (in vb multiline textbox)
Urgent int
Priority int
WasRespondedTo int

please help the error i keep getting is:
"Implicit Conversion from datatype 'varchar' to 'int' is not allowed. Use the CONVERT function to run this query."

but i cant find what is causing the error!