Combo boxes on forms displaying multiple fields ...

  • Thread starter Thread starter Jamie Risk
  • Start date Start date
J

Jamie Risk

For my form combo boxes, I often have the desire to display multiple fields.
For example, for a table,

People ( People_ID Autonumber Primary Index, Given Text, Surname Text)

my rowsource for a form's combo box would be;

SELECT People.People_ID, People.Given, People.Surname FROM People ORDER BY
People.Surname.

number of columns is 3, display widths are 0; 3; 3.

This allows me to see first and last names when I'm cruising the combo boxes
rowsource, but when I've made my selection only Given is shown.

How can I display more than one field in?
 
For my form combo boxes, I often have the desire to display multiple fields.
For example, for a table,

People ( People_ID Autonumber Primary Index, Given Text, Surname Text)

my rowsource for a form's combo box would be;

SELECT People.People_ID, People.Given, People.Surname FROM People ORDER BY
People.Surname.

number of columns is 3, display widths are 0; 3; 3.

This allows me to see first and last names when I'm cruising the combo boxes
rowsource, but when I've made my selection only Given is shown.

How can I display more than one field in?
Click to expand...

SELECT People.People_ID, People.Given &" " &People.Surname As theName
FROM People ORDER BY People.Surname.
 
Back
Top