Make combo box display 2 fields

[John Barnes]

Placed an unbound combo box on a form to allow user to
select client first and last name to run a report. When
the arrow is clicked, combo correctly shows first and last
name. When arrow is released however, only the value in
the last name field remains visible.

How do I make 2 columns stay visible once name is selected?

 

[Dan Artuso]

Hi,
Only one column can be visible in a combo.
The usual way to get around this is to concatenate the fields in the query
that feeds the combo.
Select person_id, first_name & last_name AS FullName From your table