>However, you can change the controlsource on the fly.

I tried this in the Gotfocus of the textbox and got this error message:

Parent object will not allow this property setting for ...

I there another way?