I have a combo box on a form to add an assigned employee to a project. The row source is a query. the qryEmployeeNames has fields: Employee Number, Name: [First Name] & " " & [Last Name], and Title from qryEmployees that querys tblEmployees.
All that showes in combo box on form is Employee Number. I want the complete first and last name to show up instead.