how to make drop box that displays values (first & last names)

J

josepe

i have made the drop box, i hit the arrow and i get the list i want. The
problem is once i select it only shows one colum not both. Like a name field
with first and last names.

thank you
 
D

Dirk Goldgar

josepe said:
i have made the drop box, i hit the arrow and i get the list i want.
The problem is once i select it only shows one colum not both. Like
a name field with first and last names.
Click to expand...

Set the RowSource of the combo box to a query that combines the names
into a single calculated field. The SQL for such a query might look
something like this:

SELECT
ID, LastName & ", " & FirstName As Fullname
FROM MyTable
ORDER BY LastName, FirstName;

That returns two columns, an ID column (presumably MyTable's primary
key) and a text column containing "LastName, FirstName". You would
probably use the ID column as the bound column of the combo box, but the
hide that column (by setting its width to 0) and show the FullName
column.
 
Top