No Key propery for Combo box -Help required with an alternative

[whool]

I want to display values in combo box but hide key data for each row. (With Listview or treeview you can just use the Key property but Combobox doesn't have this.) When the user hits a command button on the same form I want the Key value corresponding to the selected value in the combo to be passed as a parameter to a Store Proc on SQLSver.

I believe it should be possible to use a Datacombo control and bind it to the data but I am loath to use either of these as their properties cannot be set at run-time. (Correct me if I am wrong).

I'm am not trying to do anything out of the ordinary here; surly there is a simple solution to this problem...any clues would be much appreciated.

Thnaks in advance,

Yael

 

[RobCrombie]

You can store the keys in the ItemData property of the combo.
combo1.Itemdata(i) = ID

i being the listindex value of the current record in the combo
ID being a long value such as Autonumber primary key in an Access table

When adding records use this -

cb.AddItem RTrim(rs.Fields.Item(strItem).Value)
cb.ItemData(cb.NewIndex) = rs.Fields.Item(ID).Value Rob
rob@crombie.com

 

[whool]

Thanks Rob but this solution only works for integers. The keys I need to store are GUIDs (38 character strings)

 

[JohnYingling]

Store the GUIDS in an array that is parallel to the ComnboBox entries or store them on the right side of the Combo Box entry, wider than than the Width of the control.

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[whool]

Thanks JohnYingLing,

The paralell array sounds a good solution...quite obvious really.

Cheers,

Yael