Labels inside Loop - correct syntax? _ RESOLVED

[pounce]

I need some help with the correct syntax.
I have a form with ten labels, lbl1 - lbl10.

I need to get ten records from a database and display each record in a label. I'm not sure of the correct way to do this.
Thanks

- - - - - -

for i = 1 to 10

Lbl "(i)" = rs("word")

if not recordsetObject.EOF then
RecordsetObject.movenext

Else
Exit For
End if
Next

[vbud]

You need to create an array of labels. To do this simply set the index property of lbl1 to 0 and copy paste it ten times. then inside your code use:

for i = 1 to 10
 
Lbl1(i-1).Caption = rs("word")
 
...

[pounce]

I give you all my points!