Try something like this.
Thisform.textbox1.value = thisform.combo.list(whateverlistindex, 1)
Thisform.textbox2.value = thisform.combo.list(whateverlistindex, 2)

Basically use the list member of the combo with param 1 being the row and param 2 being the column.

-Joe

>Hi All,
>
>I'd like to store the selected rows first and second column values of a 2 column combobox created with a sql statement to two separate textboxes.
>
>I get the first column value simply using below code in the .valid of the combobox:
>
>This.Textbox.Value = this.value
>
>I can't seem to come up with the correct syntax to get the second column's value to the other textbox.
>
>TIA,
>
>Jim Harvey