Q: ComboBox value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

[Forms]![myForm]![MyComboBox] this gives me first value in a combined
combobox, how should I reach second column value?
Thanks,
 
Forms!myForm!myComboBox.Column(1)

The Column collection is zero-based, so Column(0) is the first column,
Column(1) the second, etc.
 
Hello,

[Forms]![myForm]![MyComboBox] this gives me first value in a combined
combobox, how should I reach second column value?
Thanks,
Click to expand...

Actually, it gives the Bound Column (which might be any column in the
combo).

To retrieve any column, use the combo's zero-based Column property.
The second column would be

[Forms]![myForm]![MyComboBox].Column(1)

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

Query Parameter using multiple options 0
How do i get the value from a comboxbox and link it to print. 0
fill a field from a combobox 7
ComboBox 1
Combo Box is not requerying 2
Access 2003: populate combobox with CSV values from table column 1
Refreshing combo box 2
Criteria in Querry to include All and Empty Field 9

Back
Top