Question Auto populate a text box based on the selection of a combo box

[qaaccess]

I am trying to populate multiple text boxes from combo box using one table. First text box is getting populate on base of combo box value while 2nd text box is not getting populating.

I have used the following to populate the text boxes, even row count is correct, But why is not 2nd text box is not populating ?

=[Combo2].[Column](1)
=[Combo2].[Column](2)

One thing I noted when I provide the control source then selection gets stop from combo box...I am giving the valid control source is customerID but its not working.Could it be the reason ? Why selection gets stop from combo box when provide the control source ? If remove the control source then 1st text box is getting filled on basis of combo selection and 2nd text box value is not getting filled as describe above.

Please help me in this regard. thanks.

 

[pbaldy]

Does this help?

http://www.baldyweb.com/Autofill.htm

Also, make sure the column count property of the combo is appropriate, in your case at least 3.