Thanks Eric!!!
I have a follow up question now. How do I reference only the first item in the combobox. For example:
select * from mytable where myid = combo3....??????
The easiest way is to concatenate fields:
Combo3.AddItem (rs3.Fields("itemid") & " " & rs3.Fields("descrip"))
>I am using the following code to populate the 1st column of a combobox. I want to be able to add a second column (descrip).
>
I = 0
>rs3.Open "masteritems", Splash.db
>Do While Not rs3.EOF
>Combo3.AddItem (rs3.Fields("itemid"))
>ar3(I) = rs3.Fields("itemid")
>I = I + 1
>rs3.MoveNext
>Loop
>
>The above code give me the itemid only. For example, if the table had the following records:
>
itemid descrip
>0001 item1
>0002 item2
>0003 item3
>
>all i see in my combobox is
>
>0001
>0002
>0003
>
>
>I want to see
>
>0001 item1
>0002 item2
>0003 item3
>
>Any help would be appreciated.
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson