Why my textbox wont populate past column 1

[beanhead0321]

I have a form with a combo box and a textbox. I have entered the following code in the after update of the combo box.

Private Sub Combo12_AfterUpdate()
Me.Text24 = Me.Combo12.Column(1)
End Sub

This works, but if I have the data I want in column 2 or higher in the query under my combo box, my textbox won't display anything. Why is this happening?

 

[alansidman]

Are you selecting the right column number? I believe the column numbers start with zero. The first column to the left is zero, the second is one, etc.

Alan

 

[boblarson]

You also have to set the combo's COLUMN COUNT to the number of columns in the row source for them to show up. If you just left it at the default of 1 then the second wouldn't show up at all. Go change it to 2.

 

[beanhead0321]

I think setting the column count on my combo box is the problem. How do I go about fixing that?

 

[beanhead0321]

Got the problem fix! Thanks guys!

Wait, nope. Now all four columns are showing up in my combo box when it drops down. Is there a way to only have one show up but have the others populate their respective textboxes? I tried unchecking the show, but then it just completely takes off the whole column.

 

[beanhead0321]

O, I got it. =D Thank for all the help