Columns[2] not working, not populating field

[JustLearning]

So I have this table with 4 headers (Center, Manager, Specialist, Analyst). On my form, I call this table to populate the Manager, Specialist and Analyst text boxes when they select what Center they need. I have this code:

Private Sub Center_AfterUpdate()


Me.Specialist = Me.Center.Column(1)
Me.Manager = Me.Center.Column(2)


Me.Analyst = Me.Center.Column(3)


End Sub

However, it only populates the Specialist field, leaving the other ones blank. Any ideas?


EDIT with another question: I'm trying to find the value of a specific cell in a split datasheet form, I have the column I need and the value of another item in the row, how would I go about this? (Basically, I have a column that lists the number of requests, and a number that puts a value to those requests. I want to figure out the highest number of the requests, and then figure out the value of that request. The highest request isn't always the latest one, so I can't use max.

[RuralGuy]

What kind of control is the Center control? Is it a ComboBox?

[JustLearning]

Yup, It's a combobox with a list of all the Centers (from the table)

[Missinglinq]

With the Combobox selected, go to Properties - Format; what appears in the Column Count Property?

Linq ;0)>

[JustLearning]

I had it set to 1, but when I set it to 4 all the names show up in a row. However, it will populate when I set it to 4. Is it possible to only show the first column as options?

[RuralGuy]

Yep...by setting the ColumnWidths to 1";0";0";0"...or whatever you need.

[JustLearning]

Worked perfectly, thanks! Any ideas on the second question?

[RuralGuy]

How about starting a new thread with your second question?