I know it seems trivial; however, we seem to be using textbox and labels interchangeably and they quite simply are not the same. Perhaps it's the Chemist in me that insists on proper nomenclature ;)
However,
+ In one instance we seem to be talking about the labels and changing their captions
+ In the next we seem to be talking about changing names
+ Now we appear to be talking about the control source... which textbox controls have; however, labels do not have such a property, furthermore, changing the name of the control has nothing to do with either the caption of the label nor the controlsource of the textbox.
So, SSH1223, which type of control are you talking about?
SSH1223. if you will normalize your database, you could filter the recordsource based on a textbox/combobox/listbox-control and apply the proper formula/business model to the data.
Furthermore, if the data uses the same fields, then one should only need to change the form's record source not the individual controls, unless you've "hard coded" them into their control sources, other than the captions in the labels.