>So I set the control source to none, and put "this.value = " plus the IIF above in the refresh event. Unfortunately, it doesn't work dynamically. It takes the result of the first item on the checklist and puts that for all of them.

did you forget to set the .Sparse property
of the column control?