Combo boxes

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

Guest

I am trying to creat a combo box that has two columns. One column has the
value NSN from table NSN and the other column has the value ITT Price from
the column NSN. I can get this to work in the drop down menu of the box but
I can not get both values to appear in the table. Only column one appears.
I think I am doing something wrong in the code. If it is of any help I am
using microsoft access 2003
 
Change the property ColumnCount = 2 for your comboBox and erase any value
from columnWidth. I may work.

Mauricio Silva
 
Effie,

As I recall, you cannot display more than one column in an Access combo box,
except when it is dropped down. You might want to consider using a listbox.
You could set it up to display only one row by setting the height to a value
that works for you. Then, in the lists gotfocus event, you could change the
height to some larger value to display more values, and in the lists click
event, you can reduce the height back to the original value.

HTH
Dale
 
Back
Top