Guys, i have a very strange problem.
I have a List Box named listDisplay, and its RowSource is a query named as qryList.
Case 1: The Ununique Records property of qryList is No. listDisplay can display correctly, but it has duplicate records in side, which i do not want.
Case 2: The Ununique Reocrds property of qryList is Yes. This time listDisplay shows nothing.
Why in case 1 listDisplay can work properly but it fails in case 2?