Formatting Combo Box on Form

[wilderfan]

I have a form with a combo box on it.

The combo box is based on a query which selects 3 fields from a table:

primary key (autonumber)
FirstName
LastName

The column width property for the combo box is set up so that only the FirstName and LastName are visible to the user when the user selects the desired name.

NOTE: The bound column is actually column 1 (the primary key).

After selecting the desired name, the focus switches from the combo box to some text boxes on the form. When the focus changes, only the FirstName value is visible in the combo box. The LastName value disappears.

QUESTION:
Is there a way to keep BOTH the FirstName value and the LastName value visible when the focus changes from the combo box to something else?

 

[boblarson]

In the underlying query just create a concatenated field instead of using separate fields:

MyName:[FirstName] & " " & [LastName]