Why does the checkbox give mixed status in response?

Question

Visual Basic

It is necessary that in checkboxes it gives out the status checked / unchecked. I wrote a request, but in response it gives the mixed status. I think it's all about the myabsent data type. Then how to convert to integer?
For i = 0 To 2
absent = Array(Me.fdsf1, Me.fdsf2)
myabsent = " Select absent from dbo_attendance where ([studentid] = " & Me.att_studentlist.Column(0, i) & " AND [am_day] = " & Me.att_day & " AND [am_month] = " & Me.att_month & ");"
absent(i).Value =
myabsentNext

Answer 1

It's all about setting up the checkbox itself. You need to go to properties-Data and remove Triple Status