ComboBox Visual Basic 2005

[Bruno43]

Hi I have a question about the Combo Box

This is the only Code I have seemed to be able to find to add items to a Combo Box... Is there a way to modify it or another command that I could use to have my own index or value inserted, but display the text NewField

Me.evSelectName.Items.Add("NewField")

So that when the click 'NewField' the value stored/read would equal something else?

Thanks in advance!

[kadghar]

Hi I have a question about the Combo Box

This is the only Code I have seemed to be able to find to add items to a Combo Box... Is there a way to modify it or another command that I could use to have my own index or value inserted, but display the text NewField

Me.evSelectName.Items.Add("NewField")

So that when the click 'NewField' the value stored/read would equal something else?

Thanks in advance!

combobox1.list = Array
will add an array to your combo box

combobox1.addit em ("newfield")
will add an item

if you want to know the index of the item you have selected use combobox1.listi ndex

lets say you want a msgbox that shows the item you've selected this could work:

msgbox combobox1.list( combobox1.listi ndex)

HTH

[Bruno43]

Thanks, but I guess I haven't made myself to clear and after second read of my own question it did need a little clarification

I am trying to read the Combobox items from a Database

 
        'Build Full Employee Data Set'
        Dim sql As String
        Dim empDS As New DataSet
        Dim maxrows As Integer
        Dim inc As Integer
        con.Open()
        sql = "SELECT FirstName, LastName FROM Employee_table"
        da = New OleDb.OleDbDataAdapter(sql, con)
        da.Fill(empDS, "Employees")
        con.Close()
        maxrows = empDS.Tables("Employees").Rows.Count
        inc = 0
        Do Until inc = maxrows
            Me.evSelectName.Items.Add(empDS.Tables("Employees").Rows(inc).Item("LastName") & ", " & empDS.Tables("Employees").Rows(inc).Item("FirstName"))
            inc = inc + 1
        Loop
 
 

When I do this I want to set the employee ID as the value/selected index so that in another program I can pull the Employee ID.

Thanks!