Set BoundColumn to 2. Then cboSubComplnt.DisplayValue will be the value in column 1 and cboSubComplnt.Value will be the value in column 2.

HTH
Barbara

>I do I grab the column 2 selected value from my combobox drop-down list?
>
>In the Valid Event of my combobox I have a SELECT as follows:
>
>It seems to only grabs column 1 when I use THIS.Value. I only want to grab column 2, never column 1.
>
>

>SELECT lookup.desc, lookup.mailcode, lookup.code FROM lookup ;
>WHERE lookup.code = 28 AND THIS.Value = ALLT(lookup.mailcode) ;
>INTO ARRAY asubcomplaint
>THISFORM.cboSubComplnt.Requery
>THISFORM.cboSubComplnt.Refresh
>

>
>TIA!