>If a textbox has a controlsource of a table field, am I right in saying that the controlsource will not be updated until the textbox has lost the focus?

Its actually before the Valid() which is before LostFocus(). But you're right in thinking that nothing happens during simple key strokes.

Anyway, this is why you should using buffering in on data, so you can revert if you need to.