Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: RowSource of List Box

    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?

    Thanks!

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try to change your Query SQL to use SELECT DISTINCT or SELECT DISTINCTROW and let the The Ununique Records property as its default

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •