ComboBox Captions for columns in a popup form

[Graybeard]

I have an unbound popup form with a combobox that lets the user looks up a clients phone numbers and email address. Each client may have up to 3 phone numbers-home, work and cell plus a fax number. Thus there are 4 columns of phone numbers plus a column for email addresss. Is there a way to add a caption to each column in the combo box so the user knows which phone number is which?

 

[dt01pqt]

Yes

E.g. if you are using a table as your row source:

SELECT DISTINCTROW [Contacts].[Home Phone], [Contacts].[Work Phone], [Contacts].[Email] FROM [Contacts];

Then simply set collumn heads to yes.

 

[Graybeard]

thanks dt. Im using a select query based on my client table:

SELECT QryClientPhoneNumbers.ClientID, QryClientPhoneNumbers.LName, QryClientPhoneNumbers.FName, QryClientPhoneNumbers.MidInit, QryClientPhoneNumbers.HPhone, QryClientPhoneNumbers.WPhone, QryClientPhoneNumbers.CellPhone, QryClientPhoneNumbers.FaxNumber, QryClientPhoneNumbers.EmailAddress FROM QryClientPhoneNumbers ORDER BY [LName], [FName], [MidInit];

Does it make a difference?

 

[Graybeard]

Never mind. I found it and it works. I apologize. I should have taken a closer look at the combobox properties and never posted the question in the first place. Sorry everyone. Ill be more careful next time

 

[dt01pqt]

No problem. Sometimes it is question of terminology.