Check box to if statement issues

[wlkr.jk]

Hi,

I'm having some issues making my if statement properly read the input from the check boxes I have set up.



I have 2 checkboxes set up in my form. One is "chkOverdue" and the other is "chkOnTime".

This is the code I'm using:

    If Me.chkOnTime = -1 And Me.chkOverdue = 0 Then        
        tempOnTime = " AND [DatetobeClosed]>Date()"
    ElseIf Me.chkOnTime = 0 And Me.chkOverdue = -1 Then
        tempOnTime = " AND [DatetobeClosed]<=Date()"
    Else
        tempOnTime = ""
    End If

I've also tried using True (in place of -1) and False (in place of 0) and that doesn't work either. Regardless of what combination is checked off on the checkboxes, the code always goes to the else statement.

Thanks

[wlkr.jk]

So I did some further investigation.

Even though Triple state was disabled, it seemed to automatically default to null instead of 0. I didn't even consider this because triple state was disabled.

None the less, this doesn't seem right. All I did was set the default value of both check boxes to 0....does anyone know why I have to do this?

[Missinglinq]

Is the Checkbox Bound to a Field in the underlying Table/Query? If it is Unbound, it will exhibit this behavior if it is never ticked; once ticked then unticked the value will be 0.

If this is the case you can use something like

If Me.chkOnTime = -1 And Me.chkOverdue <> -1 Then

Linq ;0)>

[wlkr.jk]

Not bound.

Great thanks.