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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
b/Extracting value from Multi column combo box/
- Thread starter 1712
- Start date
MikeBronner
Programmer
How did you add text to the various columns? Best Regards and many Thanks!
Michael G. Bronner X-)
"They who drink beer will think beer." Washington Irving
Michael G. Bronner X-)
"They who drink beer will think beer." Washington Irving
- Thread starter
- #3
i looped through the recordset and loaded two columns to each row. I am having trouble understanding how to manipulate data in a row. In other words if I click on the selected item(combo box) and want to extract just the column, how do I find the row value so I can reference it in an assign statement.
i = 0
Do Until oRS.EOF
combo2(2).AddItem i
combo2(2).Column(0, i) = oRS!Description
combo2(2).Column(1, i) = oRS!Response_value
i = i + 1
oRS.MoveNext
loop
i = 0
Do Until oRS.EOF
combo2(2).AddItem i
combo2(2).Column(0, i) = oRS!Description
combo2(2).Column(1, i) = oRS!Response_value
i = i + 1
oRS.MoveNext
loop
- Status
