Multi Column Combo Box on a form

[RayMilhon]

I have an Access 2010 Database for a Survey our company is doing. We have a Call list table to generate the list of members to be called. We also have a results table where the survey results are stored.



The survey is on a Form with 5 Questions all yes/no fields. 1 combo box for the type of survey being done and 1 combo box for the member to be called. The Row source from that combo box pulls a list of members from the call list table that have not been called yet. The combo box has 5 fields: MemberID, lastname, firstname, middle initial, Phone number. the MemberID is the bound field and that is what is stored in the survey table.

What I noticed is when the user clicks on the arrow in the member combo box the 4 fields (name fields, phone number) are displayed once the name is selected the combo box only displays the last name, nothing else is there any way to make the combo box display all 4 fields even after selection so the user can see everything there while clicking on the members responses to the survey?

[pbaldy]

Options include this:

BaldyWeb - Autofill

And creating/displaying a field in the combo that concatenates the values into a single field. You could also use a list box instead.