Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    160

    Unanswered: Combo box filtering

    Hi! ihave a table called titiles. I created a form and the form is in datasheet view whose rowsource is a query from titles table and it displays TitleID. From moving one record to another I want to filter the TitleID. That means I don't want Duplicates.

    Example:
    If there are 5 titles.
    If I select Title1, then next record should allow me to select only rest of the four titles. Is it possible?

    Thanks
    Vad

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    I am having a hard time understanding what it is that you want, could you please provide additional example of what you are trying to accomplish for me

    S-

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Perhaps you should use SELECT DISTINCTROW

    OR

    SELECT DISTINCT

  4. #4
    Join Date
    Aug 2003
    Posts
    160
    I wrote in the rowsourse property SELECT DISTINCT *FROM qryTitles.

    Still it is accepting the duplicates.

    Any Help.

    Originally posted by hammbakka
    Perhaps you should use SELECT DISTINCTROW

    OR

    SELECT DISTINCT
    Vad

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by vad
    I wrote in the rowsourse property SELECT DISTINCT *FROM qryTitles.

    Still it is accepting the duplicates.

    Any Help.
    If your relation is 1:n and you have more entries for your records in your master table, you would not be able to display unrepeated records.

Posting Permissions

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