What is the rowsource for the combo box? If it's an alias, for example, then for the second text box, use domething like:
ThisForm.Textbox2.Value = Eval(Field(2, This.RowSource))
The value of the 2nd field isn't really held in the combobox, so you need to go to the record itelf.
Alan
>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