Formatting multiple column combo box

[Guest]

Is is possible to format a combo box with multiple columns from a table so
that the fields aren't listed as columns?

For instance, my combo box contains two fields, FirstName and LastName.
Rather than the combo box showing the two separate columns, would it be
possible to format the combo box so that it displays the contents as

LastName, FirstName

?

Thanks!

 

[Guest]

Hi, Emmweb.

Sure; just change the combo box' RowSource to a query that creates a
calculated field from your table. For example, for an Employees table:

CHANGE:
SELECT Employees.EmpID, Employees.FirstName, Employees.LastName
FROM Employees;

TO:
SELECT Employees.EmpID, [LastName] & ", " & [FirstName] AS CombinedName
FROM Employees;

Hope that helps.
Sprinks