Combo box Event

[AXAMartin]

Good day, I have this event on a combo box

Private Sub Agent_Name_AfterUpdate()
Me.Agent_ID = Me.Agent_name.Column(1) (this one works)
Me.Team_Manager = Me.Agent_name.Column(3) (this one does not)
End Sub

any Ideas why

thanks

 

[theDBguy]

Hi. Hard to say... What does "doesn't work" mean? Were you getting an error message? What is the data type of Team_Manager? What is in the RowSource property of your combo? What is in the Column Count and Column Widths properties?

 

[AXAMartin]

Hi. Hard to say... What does "doesn't work" mean? Were you getting an error message? What is the data type of Team_Manager? What is in the RowSource property of your combo? What is in the Column Count and Column Widths properties?

Sorry, I mean it does not populate the Team Manager

 

[Uncle Gizmo]

Does "Agent_name" have FOUR Columns in it?

 

[theDBguy]

Sorry, I mean it does not populate the Team Manager

Okay, what about the answers to my other questions? If we knew more information about your form, we can better guess at a possible solution for you. You know column index is zero-based, right?

 

[Gasman]

Column count starts at 0 ?

 

[missinglinq]

That's correct.

Linq ;0)>

 

[AXAMartin]

Hi. Hard to say... What does "doesn't work" mean? Were you getting an error message? What is the data type of Team_Manager? What is in the RowSource property of your combo? What is in the Column Count and Column Widths properties?

Were do I see the column count and widths

 

[Uncle Gizmo]

Were do I see the column count and widths

See this YouTube:- https://youtu.be/RMUtsFhNAzI?t=68

And more on my Website HERE:-
Display Data from a Combo Box in a Text Box

And Here:-
Combo Boxes -

 

[AXAMartin]

And more on my Website HERE:-


OMG something that simple caused me hours of work... thank you sooo much Gizmo

 

[theDBguy]

And more on my Website HERE:-


OMG something that simple caused me hours of work... thank you sooo much Gizmo

Hi. Glad to hear you got it sorted out. Good luck with your project.


Uncle - Thanks for the assist!