Put all you text boxes in the same container (like a frame) and
put this code in the myText_Change even. This loops through all the text boxes in the same container
dim obj as control
for each obj in me.control
if typeof obj is TextBox then
if obj <> myText then
if obj.parent = myText.parent then
'' do whatever with obj
But be careful that this introduces a reintrance!
Another way to deal with this problem is to create an array of text boxes (much easier)
Marco
|