Query by Form Yes/No

[agibsonsw]

Hello. Access 2007.
I'm creating a form with unbound controls, with a button which then opens a form using the unbound data
as search criteria.
I have a Yes/No control on the search form. If it's unchecked (null?) initially I want to show all the records, but
my expression doesn't work. I've tried
IIF(Forms!frmSearch!cbkBonus Is Null,Yes Or No Or Is Null,Forms!frmSearch!cbkBonus)
How can I get this to work? Thanks Andy.

[HansV]

So if cbkBonus is unchecked, you want to display all records. What should happen if cbkBonus is checked?

[agibsonsw]

Currently, if they check or uncheck it I want to show staff who do or do not have a bonus. But when the form is first
opened, if they ignore it I want to show all records. (This may appear slightly illogical?!) Andy.

[HansV]

Set the Triple State property of cbkBonus to Yes; you can then toggle the check box between three instead of two states: Yes, No and undetermined.

Set the condition for the bonus field to

Forms!frmSearch!cbkBonus Or (Forms!frmSearch!cbkBonus Is Null)

[agibsonsw]

Thank you, I'll try that. Andy.