Multiple text boxes retrieving data from combobox source

  • Thread starter Thread starter hansjhamm
  • Start date Start date
H

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
 
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?
 
Back
Top