>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!
Instead of Value use this.List(this.ListIndex,2)
Insanity: Doing the same thing over and over and expecting different results.