>>>>I have a list box that is bound to coluimn 1 but I need the value in
>>>>column 2. Not sure on the correct syntax.
>>>>
>>>>ThisForm.CClist.?????????
>>>>
>>>>Thanks
>>>>Andy
>>>
>>>

>>>WITH thisform.CClist
>>>     .BoundColumn = 2
>>>     .BounfTo = .t.
>>>     .RowSourceType = 6 && Fields
>>>     .RowSource = "MyTableField1, FieldValueOfTheControl"
>>>ENDWITH
>>>

>>
>>I thought there is something like thisform.CClist.Value.[2] or something close to that
>
>Now I am not sure what you are asking :-)
>I think you have 2 columns in a listbox and want to bound column 2 to return the value of that listbox. Am I right?

Almost. I have 2 columns and I have it bound to 1 as I want it but need to get the value only once from column 2. Only 1 column is shown in the list box, column 2. I have it bound to column 1 becuase I need that value to use in a query but need column 2 value to show on a report header.