I have the code below and what I want to do is increment the textbox to match I. so Query_age1 would go into textbox1, Query_age2 would go into textbox2, Query_age3 would go into textbox3 etc.
Can anybody point me at the right syntax?
[/code]
Can anybody point me at the right syntax?
Code:
For I = 1 To 120 Step 1
Query_Age = "Age" & I
Me.TextBox1.Value = rs.Fields(Query_Age)
Next I
[/code]