MS Access: Display two columns in combo-box

Question

Embarrassingly simple question but I can't work it out or find the answer via google.

Got something like this with two colums

But when selected it only displays one column, making the information much harder to read/ understand.

Tried changing properties in property sheet (such as column number) but to no apparent effect.

Answer 1

It depends to a certain extent on what you are doing, often something like this suits:

SELECT Id, Surname & ", " & Forename from Table

In other words, the bound column is a unique ID and the selection column includes both the surname and forename in a single column.

EDIT based on additional information:

SELECT [Contact].[CID], [Contact].[Csname] & ", " & [Contact].[Cfname] 
FROM [Contact] ORDER BY [CID], [Csname], [Cfname];