Multiple text boxes retrieving data from combobox source

[hansjhamm]

I have my combobox...CBOStrNum and multiple text boxes looking up the
appropriate data in a table based on the combobox

Combo box is unbound, Bound Column is set to 1
My first textbox in the control source is: =CBOStrNum.Column(1) which
works fine...
My Second textbox in the control source is : =CBOStrNum.Column(2) which
does nothing along with all the subsequent textboxes. If I change the
second control source to the exact same control as textbox 1 then it
works (but not showing the data that I need, just duplicated data)
Why is this?


Hans

 

[John Vinson]

I have my combobox...CBOStrNum and multiple text boxes looking up the
appropriate data in a table based on the combobox

Combo box is unbound, Bound Column is set to 1
My first textbox in the control source is: =CBOStrNum.Column(1) which
works fine...
My Second textbox in the control source is : =CBOStrNum.Column(2) which
does nothing along with all the subsequent textboxes. If I change the
second control source to the exact same control as textbox 1 then it
works (but not showing the data that I need, just duplicated data)
Why is this?


Hans

Does the RowSource of the combo have all the columns you want to see? And is
its ColumnCount large enough to include all the fields?