Paul, as well as myself, are assuming that you're actually talking about Textboxes, rather than Labels, because Labels have neither Values nor ControlSources. Also, it's not possible that this method has ever worked for you. As Paul said, you'd have to use the DLookup() function for this kind of thing.
We really need to have the Label/Textbox thing clarified, before getting further into this thing for you.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007