check

[patatrac]

HI for all
I have problem with checkbox in a form and command query by it.
This code don't would work.
With -1 is ok but with 0(unchecked) the query result is null:banghead:

Like IIf([forms]![RE]![cont]=-1;[Campo1];[Campo1] Not Like " QS*" And ([Tabella1].[Campo1]) Not Like "AS*")

 

[boblarson]

Are you absolutely sure that the checkbox is unchecked or is it in the null state? When opening your form you should set the checkbox to NO if it is an unbound checkbox otherwise it is null.

Private Sub Form_Open(Cancel As Integer)
   Me.CheckBoxNameHere = 0
End If

 

[patatrac]

Hi Thanks
this is the file.
I don't understand why no work