Is it possible to create a combo box which displays multiple columns, each with column header, when the list is dropped down? .. with just the value in the first column displayed when an item is selected.
eg I have tblPerson with fields PersonN, PersonID, LastName, FirstName, MiddleName
and I want a combo box to have displayed columns (when list dropped down) of PersonID, LastName, FirstName, MiddleName .. with "ID", "Last Name", "First Name", "Middle Name" on column headers .. and with PersonN as the ValueMember .. and just PersonID
will be displayed in the combo when selection made.
Is this possible and, if so, how please?