combox problem

  • Thread starter Thread starter TomT
  • Start date Start date
T

TomT

This is probably simple. I must be overlooking something
can someone assist me on this?

I have a combobox that pulls information from a query. It
is bound to column 2. I want to display the 1st and 2nd
column when I use the dropdown. But then I want to
display the second column in the box. I can get both to
display when I use the dropdown, but then it only displays
the 1st column when I leave the field. I don't understand
what I could be doing wrong.

Can someone assist me on this?

Thanks in advance
 
The column that is displayed in the textbox portion of the combo box is the
first visible column. If you want the other column displayed, you would need
to reverse the order (left to right) of these two columns in the query. This
will also mean changing the bound column from 2 to 1. Another option is to
display both. You could place a textbox next to the combo box and set the
textbox's control source to

=cboMyCombo.Column(1)

The Column property is zero based, so 1 is the second column.
 
Thanks for the feedback. I already considered all of
this. I thought by chance their was a way in VB to
display another column in the combobox other than the 1st
after the selection. I guess not. Thanks anyway
 
Back
Top