I think I perhaps should have changed my wording a little here.

What I meant to ask is, when is the VALUE of the textbox passed into the controlsource?

Anyway, I have an answer.

Thanks
Kev