VB 6: Store the value from combo box

[azimuth58]

have a combobox with 2 columns. First column has Company name and second column has an integer value next to it. For example,

A Company 10
B Company 20
C Company 30
D Company 40

The combo box should display Company name and store the integer value next to it in the database field. Please help.

Thanks.

[jamesd0142]

Would i be right in saying; the data is just one continuos line of text in each item of the combo box?

if this is true then you will need to use the mid / substring functions to get the integer values.

I dont think this is a good idea to have two values in the same combobox if this is the case...
cant you use two comboboxes? -or-
1 combobox and a text box to display the integer value for the selected company?

James