>>Thanks Sergey. I was doing all that except clicking on the title bar once the object was selected. Yep, that worked.
>>
>>BTW, any idea why I'd get that error when the cbx was not the currentcontrol?
>
>It's still being refreshed, because you probably had the controlsource set for the column, but not for the controls in it. In that case, the controls automatically inherit the controlsource from the column, and on every refresh the controls are assigned the value, visible or not.
>
>You could have got around this by setting the column as unbound, and assigning the controlsources to each control. You could even leave the checkbox unbound too, so you wouldn't be getting the error - but then it would be pointless if you weren't showing the checkbox at all.
Thanks. Your post has reminded me that I forgot to bind the checkboxes, which explains other erroneous behaviour I've observed.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.