Unanswered: Looping Through TextBoxes Which Include a Number
I have a number of textboxes on a form that I would like to loop through and set values in. The textbox names contain a number. For example Me.txt_box_1.value, Me.txt_box_2.value, etc. Since I want to loop through the textboxes, I would like to replace the number at the end of the textbox name with an iteration value (such as i) so that my code would (in theory) look like:
For i = 1 to some number
Me.txt_box_i.value = some calculation
I've tried a number of ways to replace the number with an iteration value (ampersands etc.) but cannot solve this problem thus far.