very easy combobox question

  • Thread starter Viktor via AccessMonster.com
  • Start date
V

Viktor via AccessMonster.com

Hi,

Probably this will make some of you smile :) but it will help me a lot.

I have a combo box that looks up first and last name in another table. The
first and the last name a re separate fields. Obviously, I'd like to have one
combobox that will show the full name
eg. combobox: Jon Dow and not two comboboxes, one for first and one for last
name eg. combobox: Jon; combobox: Doe.

How do I do this,

Thanks,
Viktor
 
D

Douglas J. Steele

Base the combo box on a query. In the query, add a computed field that adds
the two names together:

SELECT FirstName & " " & LastName AS FullName, FirstName, LastName
FROM MyTable

If you have no need for the individual parts of the name, you can leave out
the separate FirstName and LastName fields from the query.
 
Top