Combo Box values problem

Hi,
I don't have in this particular moment Visual Studio 6 installed on this computer, so , sorry I can't give you an exact example.But I hope I can help you anyway.

In combobox you set as a bound column deptId and as a ListField DeptName
when you select an deptname from Combo, you also have the DeptId associated to it.(I think the property is called BoundText, you have to search that). You can obtain it on SelectedIndex_Change event of the combobox.
Now, you can hold trhe selected index's deptId, store it in an variable and insert it where you want to.
Daniela

Hi,
I don't have in this particular moment Visual Studio 6 installed on this computer, so , sorry I can't give you an exact example.But I hope I can help you anyway.

In combobox you set as a bound column deptId and as a ListField DeptName
when you select an deptname from Combo, you also have the DeptId associated to it.(I think the property is called BoundText, you have to search that). You can obtain it on SelectedIndex_Change event of the combobox.
Now, you can hold trhe selected index's deptId, store it in an variable and insert it where you want to.
Daniela
Aren't you thinking about Visual Basic.NET ;)

I have a table named department having fields (deptID, deptName)....I am trying to get the all deptName from department into combobox......but I also want to insert deptID into another table named employee whenever I select a particular deptName from combobox..its related deptID should be entered in employee table...but I don't know the way how to do it as I have deptName in combo box but not deptID..
I know what do you mean. Use the Collection for solving your problem.

Public Sub AddDataInCombo(ComboName As ComboBox, RsLocal As Recordset, TextData As Integer, Optional ComboItemData As Integer = -1)
Rem this function is to add the data in ur combobox after fetching the data from database with ur id.
If RsLocal.State = adStateClosed Then Exit Sub
With ComboName
.Clear
If RsLocal.RecordCount <> 0 Then
Do Until RsLocal.EOF
.AddItem RsLocal(TextData)
If ComboItemData <> -1 Then
.ItemData(.NewIndex) = Val(RsLocal(ComboItemData))
End If
RsLocal.MoveNext
Loop
End If
End With
End Sub

you have to use this funciton for data population in combo.

while saving the value you have to use the listindex and itemdata value of ur combo. and it will save the id of department not the name of it.

Hope it helps!!
Take Care!!

Hi,
Yes, I I confused that.It was an solution, but when you used DataCombo, component available when including as a project reference Microsoft Activex DataObject Library 2..., not the simple combobox. I don't know your project, but you might consider use DataCombo.
Daniela