Drop down list- display and store last & first name

[Guest]

I have created a drop down list that displays the last
and first name a two different fields. when i select the
name I would like it only stores and displays the last
name. I would like it to display both the last and first
name on the form.

Please help?? How can i do this.

Thanks,
barb

 

[Ken Snell [MVP]]

What you want to do appears to not be a good idea.... fields should not
contain combined data because it's difficult to separate them back out.
However, if you're just storing info for printing out, etc., then what
you're doing may be ok.

Use a query as the Row Source of the combo box:
SELECT [FirstName] & " " & [LastName], [LastName], [FirstName] FROM
TableName;

Set the combo box's Bound Column to 1. Set the Column Count to 3. Set the
Column Widths to 1";.0.5",0.5".

This will show the combined names, last name, and first name in the dropdown
list, and will display the combined name in the combo box after selecting.

A combo box will display (when the dropdown list is not showing) only the
first visible column.