CODEWITHSUNDEEP
ms-accessvbams-access-2010
roubi
roubi

Reputation: 3

Display from two column ComboBox

I have a lastName, firstName sorted ComboBox. After having made a selection from this ComboBox only lastName is displayed. But I need both lastName AND firstName being displayed. What settings do I have to set in order to display both values?

Upvotes: 0

Views: 109

Answers (1)

spiderko_2
spiderko_2

Reputation: 118

On combobox properties:

  • set "Column Count" to 3
  • set "Column Widths" to 0;0;1
  • set your "Row Source" to get 3 columns, for example query: SELECT LastName,FirstName,FirstName + ' ' + LastName AS FirstAndLastName FROM Table1 ORDER BY LastName,FirstName

Upvotes: 1

Related Questions