Combo Box woes WAS:"Hi folks, I am"-Sorry for lack of subject

[BrianB]

Hi folks,

I am new to VB (from Access VBA) and have what must be a simple problem.

I have a table of records containing both ID numbers and names. I want a combo box that displays the names yet stores the numbers. In Access, one would put a combo box on the form, set it to two columns with column 0 set to zero width. Then one would set the combo’s rowsource to a query with SQL of:

SELECT id, name FROM table ORDER BY name;

In VB, we have to use the AddItem method. How do I get a combo box that stores one value, but displays another? Indexes must be sequential, starting with zero, so they are not what I want.

This is so simple that there must be an easy answer to this. Thanks!

-Brian

 

[VBVines]

Set rs = conn.Execute("Select * From SomeTable&quot
Do Until rs.EOF
Combo1.AddItem rs("SomeField&quot
Combo1.ItemData(Combo1.NewIndex) = rs("TheIndex&quot
rs.MoveNext
Loop
=========
This will populate the combo box for you using the index in a sequential manner.

aspvbwannab