>>Wow, thanks a lot - I didn't know that was possible. I always used the Refresh() event, but that looks clumsy compared to just assigning the ControlSource.
>
>The side effect is that the control become Read-Only. It is a bug for me.
I don't think this is a bug. I mean, what would you expect?
You can assign a value to a variable, but not to an arbitrary expression.
For instance, the following is a valid assignment:
x = a + 1
But the following is not:
x + y = a + 1
I mean, where should "a + 1" in this example be copied to?
As I see it, the case is similar for the ControlSource, which implies a "store" or a "replace", depending on the case.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)