Displaying more multiple values in combo box.

[Max]

Hello all,

I have a combo box on my form. Source data for the combo
box is a select query that provides six columns of
essential information. When selecting a value form the
combo box user can see all six values in the drop down
list.

However, is there a way to have all six (or at least
three) values displayed when selection is made and control
has no focus any longer?

Please advise on possible solutions. Thank you.

 

[Brian]

The easiest way to accomplish this is to create 5
TextBoxes (if you want all 6 columns) to go along with the
ComboBox. When the change is made, you can populate the
other TextBoxes by using something, like the following, in
the control source for each:

=Forms![FormName].[ComboBoxName].Column(1)

Note: The first value in the ComboBox is read as Column(0)
and the last Column(5). To make sure that the data is
always current, you can put a .Requery command for the
TextBoxes, into the On Change event of the ComboBox.

 

[Gary Miller]

Max,

In addition to the other suggestion made, you could also create a subform
that holds those pieces of information from the query and make the
form/subform relationship the value of the key field in the combobox. Now
the info will automatically populate the subform when you make a choice.

Gary Miller