Multi-column combobox only showing first column

[Joseph Greenberg]

I have a bound 2 column combobox with the following row rowsource SQL:
SELECT DISTINCT qryGetFirstNames.SeqNo, qryGetFirstNames.Fname,
qYDetail.FamNo FROM qYtDetail INNER JOIN qryGetFirstNames ON qYDetail.FamNo
= qryGetFirstNames.FamNo WHERE
(((qYDetail.FamNo)=[Forms]![fMemberInfo]![FamNo])) ORDER BY
qryGetFirstNames.SeqNo;

When I click the down arrow on the cbo, it correcly shows me the 2 columns,
however when I'm just scrolling through records (and the cbo isn't
displaying a list, it's displaying the current bound value), it only shows
me the bound value - it is only showing me the first of the two columns. How
can I get the cbo to display both columns when it is "at rest" (for lack of
a better word?

Thanks.

 

[Jeanette Cunningham]

Put an unbound textbox next to the combo.
Set its control source =
[NameOfCombo].Column(n)

n is the number for the column you want.
Combo column numbering starts at 0 for the 1st column, 1 for the 2nd column
and so on.

Replace NameOfCombo with your object name.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia