I think sorted it out...
Set the combobox.style property to 2 for a dropdown list box
Set the combobox.RowSource Type to 5 for an Array
Set the combobox.RowSource to the array that contains the data
Set the combobox.BoundColumn to the column that has the data you want to be stored in the combobox.Value property when a selection is made
>I have a combo box with two columns. The data is stored in an array that is part of the combobox.
>
>
>WITH Thisform
>
> SELECT DISTINCT RodSpec.Mill , RodSpec.MillId;
> FROM WireMill!RodSpec ;
> ORDER BY RodSpec.Mill;
> INTO ARRAY .cboMill.cboData
>
> =ASORT(.cboMill.cboData)
> .cboMill.DISPLAYVALUE = .cboMill.LIST(1)
>ENDWITH
>
>
>
>When I select a value from the combo box I need to know the value in column 2. How do I reference it?
>
>Thanks