Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    5

    Unanswered: Removing Duplicates from Drop Down Box

    I have a drop down box that has a list of names in it and i just need to remove the duplicate values from it. Say it looks like this:
    A
    A
    B
    C

    I only want it to look like this:
    A
    B
    C

    and get rid of the second A. I don't know why i can't figure this out, its driving me crazy. Thanks for any help you have in advance!

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Use the DISTINCT clause in your select statment for you recordsource

    SELECT DISTINCT...
    Inspiration Through Fermentation

  3. #3
    Join Date
    Feb 2005
    Posts
    5
    Thanks!!! Don't ask me why i couldn't think of or remember that. I think sat here looking around for like 2 hours trying to find something like that. Appreicate it

Posting Permissions

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