Displaying Multiple Fields in a drop down menu

  • Thread starter Thread starter Kyle D
  • Start date Start date
K

Kyle D

Hello,

I have a question relating to lookup drop down boxes. I have several
drop down boxes in my forms which select a name. However, in the
table the name is divided separate fields for first, middle, last.
Once you select a name the box only displays the first name. Is there
a way to make access 2007 display the full name in the box?
 
In the rowsource for your combo box create another column which joins up the
three names. The content of that column
will be something like =firstname & " " & lastname

let that column be the one that shows in the combo box after you select
 
Assuming your source looks something like this --
SELECT [ID], [FName], [LName], [Dept] FROM TableX;

Change it to this --
SELECT [ID], [FName] & " " & [LName] & " - " & [Dept] FROM TableX;
 
Assuming your source looks something like this --
SELECT [ID], [FName], [LName], [Dept] FROM TableX;

Change it to this --
SELECT [ID], [FName] & " " & [LName] & " - " & [Dept] FROM TableX;

--
Build a little, test a little.

Kyle D said:
Hello,
Click to expand...
I have a question relating to lookup drop down boxes.  I have several
drop down boxes in my forms which select a name.  However, in the
table the name is divided separate fields for first, middle, last.
Once you select a name the box only displays the first name.  Is there
a way to make access 2007 display the full name in the box?
Click to expand...
Click to expand...

Thanks so much.
 
Back
Top