Filter Combo based on checkbox with null value (1 Viewer)

[Danick]

I'm trying to filter a combo box using a three way checkbox in a similar to the way of doing the cascading combo box by using something like this in the combo row source

[Forms]![FormName]![CheckBoxName]

This works when the checkbox is True or False, but not if it's Null. Anyway to show all records in the combobox when the checkbox is Null?

Thanks

 

[theDBguy]

Add "OR Is Null" to your criteria.

 

[Danick]

Add "OR Is Null" to your criteria.

Thanks - I tried that before posting and couldn't get it to work. But seeing that you also suggested the same thing, I tried various ways of doing this and finally got it working by adding by just repeating the first line again. So in the end I got it work by doing this.

[Forms]![FormName]![CheckBoxName]) OR ([Forms]![FormName]![CheckBoxName]) Is Null

Sometimes is just great to have some reassurance to keep from going off on a tangent when something so simple doesn't work out the first time.
Thanks again for responding...

 

[theDBguy]

Glad to hear you got it sorted out. Good luck with your project.