Getting the value of multiple column combobox

T

Tan SH

Hi,

I know that it is possible to have multiple columns in a
combobox whereby the datasource is from columns in a table.

However, I reliase that the property comboboxName.Value
would only give me the value in the bound column. How can
I get the selected values from the other columns?

br/Tan
 
A

Allen Browne

Use the combo's Column property.

The first one is called column zero, so the 2nd column is:
=[MyCombo].Column(1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Merging from an Excel file with graphics 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Multi-column combobox only showing first column 1
Excel does not accept text format! 0
Access 2003: populate combobox with CSV values from table column 1
populate a combobox based on unique values in another workbook 16
Combobox column not displaying although there is data 3

Top