display multiple fields of a combo box on a form

[Guest]

Why have a combo box if it will only show one field when selected on a form?
I need it to show several.

 

[Guest]

From another amateur Access user:

It shows only one by default but this is easy to change.
In the Properties of the combo box:
in Row Source, add in whichever other fields you want it to look up
in Column Count, increase this to however many you want to be shown
in Column Widths, adjust these as you wish
in List Width, similarly, set the width that you want

Hope this helps
CW

 

[Ron2006]

When you get off of the combo box, even with the multiple fields it
will ONLY show the bound column

However, you still have access to the other fields. You now have two
options:
If there are two other fields in that combo to show then
1) place two unbound txt boxes on the form and have the row source for
them be
=me.comboboxfieldname.column(1) for first additionalfield
AND
=me.comboboxfieldname.column(2) for second additional field

OR

2) in the oncurrent event of the form AND in the Afterupdate event of
the comboboxfieldname put
me.txtboxname1 = me.comboboxfieldname.column(1) ANd
me.txtboxname2 = me.comboboxfieldname.column(2)

Both of these examples assume that the query for the combobox have
bound column = 1 (really means first column in query)
and that the second and third columns are the two extra fields. (the
column part of the control is counted relative to 0.. first column is
column(0) second column is column(1) etc.


Ron