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.