Bound Columns

[tanyapeila]

I don't know why I have such issues wrapping my head around Bound Columns.

My typical table has ID, NAME, ADDRESS, etc, etc,

When I use a combo box I want The "Name" column to be the bound column. Problem is I ALWAYS get the ID#!

I am entering Bound column: 2.

I just don't get it.



HELP!

[ItsMe]

Comboboxes have several properties. The bound column property is used to assign one of the columns from the Rowsource to the .Value property of the combobox control.

Another way to retreive a value from a combobox os to use the Column property. Me.ComboName.Column(0) or Me.ComboName.Column(1) or Me.ComboName.Column(2)

Dim strMyString as string
strMyString = Me.ComboName.Column(1)
debug.print "The second column = " & strMyString