Displaying more multiple values in combo box.

  • Thread starter Thread starter Max
  • Start date Start date
M

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.
 
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.
 
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
 
Back
Top