Combo Box final format in form

[alexse]

Hi, I have created a combo box with 3 columns , one (key) is hidden and 2 columns are appear in selection part of combo : first_name and last_name .
Both first_name and last name are appear in opened list of combo.
When the proper pair is choosen , the final value shown in combo box is a first_name only ...
How I can make the final value shown in form to be in same format as I selecting it : first_name:last_name

[OldBirdman]

Short Answer - You can't.

If this combobox were bound to a field in a table, then if you selected a Last-First name combination and could display it in the text portion of the combobox, you would change the table to Last-First for the bound column. This would not make sense.
However, this combobox is probably not bound, You could fake it, and make what you want apparently possible.
Simplest solution might be to assign strFirst & " " & strLast into a textbox or label elsewhere on the form. User would become accostomed to looking at this display for verification of results.