Updating Text Boxes based on Dropdown Selection

[scoutwes]

I've got 6 text boxes to populate based on the selection of the users choice in a Combo box. The combo box is populated by a query with 6 fields.


I've got the following code placed in the combo boxes "after update" event code. Currently, the first two boxes (requestor and grade) are working great but the other 4 fields won't populate.


Me.Requestor = Me.Requestor_Lookup.Column(0)
Me.Grade = Me.Requestor_Lookup.Column(1)
Me.Org = Me.Requestor_Lookup.Column(2)
Me.Office_Symbol = Me.Requestor_Lookup.Column(3)
Me.Email= Me.Requestor_Lookup.Column(4)


Me.PhoneNumber = Me.Requestor_Lookup.Column(5)


Any ideas what I can do to fix this?

[davegri]

What's the rowsource for the combobox? The table or query has to include all 6 of those fields.
Also the combobox ColumnCount property must be 6.

[scoutwes]

What's the rowsource for the combobox? The table or query has to include all 6 of those fields.
Also the combobox ColumnCount property must be 6.

Thanks, this answer solved my problem! I had forgotten to set the column count to 6. I knew it was something simple that I was just overlooking.