Combo boxes on forms displaying multiple fields ...

[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?

 

[Andi Mayer]

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?

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

 

[Jamie Risk]

Thanks.

- Jamie