Combo box dispay problem

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I'm guessing that you created a select query to display
both columns in the combobox. In that case, all you have
to do is view the form in design view and right click on
the combobox, choose properties and change the "Bound
Column" setting to 1. I hope this helps.

Eric

-----Original Message-----
I have a combo box on a form that selects a InventoryID
Click to expand...
and InventoryName field from a table.
WHen the user selects the combo box, they can see both
Click to expand...
the InventoryID and InventoryName (which is what I want).
BUT, how do I make it so that after they make their
Click to expand...
selection, and move to the next control, that the only
value that shows in that combo box is the InventoryName
(currently, it shows the InventoryID in the combo box
after I proceed).
 
Change the RowSource Query / SQL so that InventoryName is the first Column
and InventoryID is the second Column. Set the BoundColumn of your ComboBox
to Column 2 and set appropriate values for the ColumnWidths Property.

The Text component of the ComboBox *always* show the first visible Column.

--
HTH
Van T. Dinh
MVP (Access)



dwalsh77 said:
In creating my Combo box, I ran through the Wizard in the design view of
Click to expand...
the form and selected the InventoryID (primary Key) (which I DO NEED to show
in the combo box when the user is selecting their choice), as well as the
corresponding InventoryName. But, after the combo box choice is selected, I
would just like to see the InventoryName by itself in the combo box (or at
least both the InventoryID and InventoryName).
 
Back
Top