Full name in Combo Box

[Guest]

I have a combo box on a subform that where I want to display and select a
person's full name. The underlying query selects the contacts for the
company displayed on the full form. The "contacts" table that the query
selects from has Last, Middle Initial, First name columns (for sorting
purposes on other forms). I want the combo box to display the full name in a
"natural" (concatenated) way (not in two columns) and then be able to select
that record to update other fields on the subform.

Any assistance would be greatly appreciated.

 

[Guest]

CReate a new query with 5 columns - Sort it by Col 4
Col 1= IDField
Col 2 = 1stname
Col 3 = MiddleName
Col 4 = LastName
Col 5 = Full:[1stname]&" "&[MiddleName]&" "[LastName]

Create a combo based on this query
Set widths 0;0;0;0;3
Bound Column is Col 1


Hope this helps - have fun

 

[Guest]

Thank you Wayne-I-M - your answer worked perfectly. It makes for a very nice
form.

CReate a new query with 5 columns - Sort it by Col 4
Col 1= IDField
Col 2 = 1stname
Col 3 = MiddleName
Col 4 = LastName
Col 5 = Full:[1stname]&" "&[MiddleName]&" "[LastName]

Create a combo based on this query
Set widths 0;0;0;0;3
Bound Column is Col 1


Hope this helps - have fun



--
Wayne
Manchester, England.

I have a combo box on a subform that where I want to display and select a
person's full name. The underlying query selects the contacts for the
company displayed on the full form. The "contacts" table that the query
selects from has Last, Middle Initial, First name columns (for sorting
purposes on other forms). I want the combo box to display the full name in a
"natural" (concatenated) way (not in two columns) and then be able to select
that record to update other fields on the subform.

Any assistance would be greatly appreciated.

 

[Guest]

Glad it worked for you.