loop with objects

[dorling]

hi there

i got the code below that need to put the number in the text box but all my object are 'round 1', 'round 2', 'round 3', all the way to 'round 176', but it is not working???

For i = 1 To 176
("Round " & i).SetFocus
["Round " & i].Text = i
Next i

thanks in advance

Jonathan D

 

[RoyVidar]

Is this form controls? Try using a fully qualified reference, either with the Me keyword (if it is within the current form) or with Forms("formname")...

[tt]For i = 1 To 176
Me("Round " & i).Value = i
Next i[/tt]

Roy-Vidar