Multi-Value Combo Box

  • Thread starter Jamie Dickerson
  • Start date
J

Jamie Dickerson

I have a combo box on a form with two columns. The first is a numeric
representation of the text values in the 2nd. I need the first column to run
a Dlookup but I want the text value to be entered into the table. I have
tried changing the bound column to the second but then the Dlookup does not
work as it is looking or numbers. Is there anyway to use column1 for the
lookup but use the values in column2 in the table?
 
D

Douglas J. Steele

You can refer to the first column of the selected row using
NameOfComboBox.Column(0), or the second column as NameOfComboBox.Column(1)

The Column collection starts numbering at 0.
 

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

list box 2 columns 1
filter on combo box possible? 1
Selection from combo box doesn't fill text box 2
2007 Multi Value Check Box Lists 1
sum combo box based on other combo box 2
Combo Box problem 4
Default Value for a Text box field 1
auto populate text box based on combo box value 1

Top