Forum Discussion
mataira
May 26, 2021Copper Contributor
two combo boxes
Kia ora team, I am new to using access so please bear with me. I am trying to link two combo boxes on a form so that when information is entered into either of the boxes, the other is auto-popul...
George_Hepworth
May 26, 2021Silver Contributor
Why do this at all? What do you gain by populating a second combo box like this? It seems redundant at best and potentially risky.
That said, the BOUND column of a combo box is Column(0), because the columns are indexed, left to right, starting with 0. The ID value is the one bound to the combo box and that would normally be in Column(0), while the text value displayed, i.e. "FullName" would be in Column(1).
There is absolutely NO reason to try to use "FullName" as the bound column in a combo box that I can see.
That said, the BOUND column of a combo box is Column(0), because the columns are indexed, left to right, starting with 0. The ID value is the one bound to the combo box and that would normally be in Column(0), while the text value displayed, i.e. "FullName" would be in Column(1).
There is absolutely NO reason to try to use "FullName" as the bound column in a combo box that I can see.