Make combo box display 2 fields

  • Thread starter Thread starter John Barnes
  • Start date Start date
J

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?
 
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
 
Back
Top