Can I merge 2 fields (first last name) into a combo box dropdown list?

[dreandre]

Hello all,
What I need to have happen is a form dropdown list with the first and last name displayed in the list. When selected I need the information to add to the new record in the table in the proper first name and last name fields. Is that possible??

 

[KornGeek]

You can easily set the combo box to display multiple columns (check out the ColumnCount and ColumnWidths properties). That would take care of displaying both fields at once.

I would recommend against storing both the first and last names in your table. I would instead store an identifier (such as EmployeeID, etc) in the table that allows you to look these up on the fly. That way, when Cindy Jones gets married and is now Cindy Smith, you only need to change her name in the one table, and it gets updated through every record. Similarly, if Charles starts going by the name Chuck, you can easily adjust his information.

 

[randysmid]

Hi,
I wrote an FAQ on how to create custom fields within the query tool. You can use this to merge last name with first name, as my example shows. faq701-3273

This query will not change anything in your database. HTH,
Randy Smith
California Teachers Association