Displaying Multiple Fields in a drop down menu

[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?

 

[Chegu Tom]

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

 

[KARL DEWEY]

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;

 

[Kyle D]

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.

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?

Thanks so much.