If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple text boxes retrieving data from combobox source
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 |
#2
|
|||
|
|||
Multiple text boxes retrieving data from combobox source
" wrote:
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? -- John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|