Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please, Help Me For This. 1

Status
Not open for further replies.

HNA

Programmer
Jan 13, 2003
87
0
0
KW
I have a form with 25 controls:

text1 .................... upto text25
and combobox has 25 index with value

I want instead of write code for all text control, to store value like this:
Me.Text1 = Me.Combo1.Column(1, 0)
Me.Text2 = Me.Combo1.Column(1, 2)
Me.Text3 = Me.Combo1.Column(1, 3)
.....
.....
.....
Any Way To Make Loop For That?

Thanx In Advance

" Åä Çááå íÍÈ ÅÐÇ Úãá ÃÍÏßã ÚãáÇ Ãä íÊÞäå "
 
Hi HNA,

Off the top of my head, this ..

Code:
For i = 1 to 25
  Me.Controls("Text" & i) = Me.Combo1.Column(1, i)
Next

.. or something similar ought to do it.

Enjoy,
Tony
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top