Combobox Field Combination

[Dustin Cook]

I have a combobox on my form that displays two different columns of
information on drop-down. However, I would like it to display both colums
when it is not dropped-down.

Specifically, I have a combobox named cmbCustomerID. It uses the
CustomerFirstName and CustomerLastName fields from tblCustomers to show two
columns of information (last name then first name) when a user drops down the
box. When they navigate away from the control, it now only displays
CustomerLastName.

If they drop down and select "Smith | Joe" then they only see "Smith" once
it's no longer dropped down. I hope I'm explaining myself well enough here.

Here is the SQL statement for it:

SELECT tblCustomers.CustomerID, tblCustomers.CustomerLastName,
tblCustomers.CustomerFirstName FROM tblCustomers ORDER BY [CustomerLastName],
[CustomerFirstName];

Will someone please tell me how to make it display Smith, Joe in the
non-dropped-down control?

 

[kingston via AccessMonster.com]

SELECT tblCustomers.CustomerID, tblCustomers.CustomerLastName & ", " &
tblCustomers.CustomerFirstName AS Customer FROM tblCustomers ORDER BY
[CustomerLastName],
[CustomerFirstName];

I have a combobox on my form that displays two different columns of
information on drop-down. However, I would like it to display both colums
when it is not dropped-down.

Specifically, I have a combobox named cmbCustomerID. It uses the
CustomerFirstName and CustomerLastName fields from tblCustomers to show two
columns of information (last name then first name) when a user drops down the
box. When they navigate away from the control, it now only displays
CustomerLastName.

If they drop down and select "Smith | Joe" then they only see "Smith" once
it's no longer dropped down. I hope I'm explaining myself well enough here.

Here is the SQL statement for it:

SELECT tblCustomers.CustomerID, tblCustomers.CustomerLastName,
tblCustomers.CustomerFirstName FROM tblCustomers ORDER BY [CustomerLastName],
[CustomerFirstName];

Will someone please tell me how to make it display Smith, Joe in the
non-dropped-down control?