Combo box display first & second names fields after being selected

[djspod]

Hi,



How do I get a Combo box to display first & last name fields from a Employee table on a form.

Thanks

[June7]

Set the RowSource like:

SELECT ID, LastName & ", " & FirstName AS FullName FROM Employees;

[djspod]

Brilliant answer and help!

Thank you [emoji2]