>I want to display column 2 of a multi-column combo box. Can someone please tell me what I must do to display the second column?
>
>Thanks,
>
>Lance
The combobox always displays the first column in the RowSource - nothing says you can't turn it around to put the desired column first, though.
For a RowSourceType of 6 (fields) or 2 (alias) - yes, 2 - you can just put the desired column first in the list, e.g., if it's field2 from the cursor
this.RowSourceType = "cursor.field2,field1"
For a RowSourceType of 3 (select) or 5 (array), you would have to reorder the fields in the code that produces said select or array.
Insanity: Doing the same thing over and over and expecting different results.