Combo Box

[Guest]

I have a combo box that pulls from another table. It contains the first and
last names of customers. When I am using this control in a from, the drop
down list shows both names, but after a selection is made, only the last name
is shown. Also, on reports related to this information, only the last name
is shown.

How do I alter the control so that both names are shown?

 

[Jeff Boyce]

Base your combobox source on a query. Base the query on the underlying data
source (?table).

In your query, add a new field ... you could do something like:

Expr1: [LastName] & ", " & [FirstName]

This will give you a "last name first" concatenated string you could display
in the combo box.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Regan via AccessMonster.com]

How do I alter the control so that both names are shown?
i am assuming you have a combo with 2 columns

goto design view, click on combos properties

Data tab
click on rowsource builder ... button

goto sql view and in there you should put somthing like this

SELECT Mytable.firstname & " " & Mytable.lastname AS Fullname
FROM Mytable;

Change the column count under format tab to 1
change the column widths

Hope it helps

 

[Guest]

This is how it looks:
SELECT [Customer Info].[Customer ID], [Customer Info].[Last Name], [Customer
Info].[First Name] AS Fullname FROM [Customer Info] ORDER BY [Last Name];

It is still not working, what did I do worng?

Thank you.

 

[Regan via AccessMonster.com]

This is how it looks:
SELECT [Customer Info].[Customer ID], [Customer Info].[Last Name], [Customer
Info].[First Name] AS Fullname FROM [Customer Info] ORDER BY [Last Name];

It is still not working, what did I do worng?

SELECT [Customer Info].[Customer ID], [Customer Info].[Last Name] & ", " &
[Customer
Info].[First Name] AS Fullname FROM [Customer Info] ORDER BY [customer Info].
[Last Name];

Try that