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

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Report Group Footer DLookUp 0
Dynamic Naming of Form Button 3
Combo box 0
Setting column width in a table with a macro is not working 0
Combo or list box 0
Combo or list box 0

Top