Multi Value ComboBox...... (1 Viewer)

[sam1fletcher]

Hey folks anyone know if it is possible to grab certain data from a multi value comboBox

EG.. MY combobox, when it when drops down, shows 3 values from another table ID, Firstname, Surname. i want to be able to JUST get the surname of the selected data?????

Sam

 

[Pat Hartman]

Combos may show multiple columns when dropped down but they only save the bound column which would normally be the unique ID of the table referenced by the combo's RowSource query. You can refer to columns other than the bound column of a combo/listbox by using its .column property.

Me.cboYourcombo.Column(3) is the FOURTH column of the RowSource. The columns are a zero-based array so .Column(0) is the first column, .Column(1) is the second column, etc.