Selecting both fields displayed in combo box

[carpstar]

Hello everyone.
I created a combo box that displays two fields from a query "FirstName" "LastName" I need for both fields to appear in the combo box once choice is selected so that both FirstName and LastName are updated as one field in designated table.
I was always told to separate names into two fields, but because of duplicate first names I need full name to be displayed on the form during entry. Is this possible with combo box or should it be done in the query and how is it done.

Thanks to all..
Rory

 

[DBL]

If you save the first and last names to separate fields in the base table, as you should, you can still view the two names together in a combo box. Base the combo box on a query that takes the autonumber field (if you have one) from the table with the names and create a concatanated field for the first and last names. In the Field row of a blank query column put:

UserName: [firstnamefield] & " " & [surnamefield]

Make sure that the autonumber field is hidden by making the column width 0 and then you would view the name field as a whole name.