>>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?

I don't think sparse affects the value of the checkbox?

I got it working with a cursor.

Thanks,

-Michelle