Solved: Indirect reference for form controls

[subwayman]

Newbie question:

I have a form with six rows of textboxes used to enter the results of a race.

Each row has text boxes named 'Lane1name', 'Lane1Position' . . .

I want to process this data in loops so need to refer to the control values indirectly. Something like:

For Lane = 1 to 6

controlname = "Lane" + format(Lane,"#") + "name"

currentlanename = controlname.value

.

.

Next Lane

Anyone got the magic answer?

Thanks in advance.

[Bob Phillips]

[vba]

For Lane = 1 to 6

currentlanename = Me.Controls("Lane" & i & "name&quot.Text
.

.

Next Lane
[/vba]

[subwayman]

Thanks. Saved me hours of browsing the help files.

Much Appreciated.

[mdmackillop]

Hi Subwayman,
Welcome to VBAX.
If your question is solved, you can mark it so using the thread tools dropdown.