Combo Box Question

[Don]

I've got a combo box with 3 columns showing. When I select a record, the box
is populated with what is in column 1. How do I have the box show what is in
column 3 without moving the column to where column 1 is in the underlying
query? Is it possible?

 

[Al Campagna]

Don,
The "textbox" portion of the combo will always display the first
"visible" column.
In order to display the 3rd column in the combo, the 1st and 2nd column
would have to be hidden. That would mean that users make a selection
according to the column 3 value... which may be unworkable.

Usually, a key field like CustID is hidden in column 1, and CustName in
column 2, and would be displayed in the combo after a selection.
Column 3 can be displayed in an unbound text control with a
ControlSource of...
=cboSomeComboName.Column(2)
(combo columns are numbered 0, 1, 2, 3, etc... when referencing through
code)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Don]

Thank you for your feedback.
--
Don Rountree

Don,
The "textbox" portion of the combo will always display the first
"visible" column.
In order to display the 3rd column in the combo, the 1st and 2nd column
would have to be hidden. That would mean that users make a selection
according to the column 3 value... which may be unworkable.

Usually, a key field like CustID is hidden in column 1, and CustName in
column 2, and would be displayed in the combo after a selection.
Column 3 can be displayed in an unbound text control with a
ControlSource of...
=cboSomeComboName.Column(2)
(combo columns are numbered 0, 1, 2, 3, etc... when referencing through
code)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."