Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Location
    Oxford, UK
    Posts
    2

    Unanswered: Dropdown menu contains multiples of the same person

    I'm trying to create a music database of all the albums and tracks from the different albums in my collection.

    I'm having trouble trying to figure out the dropdown menu bit. As you know every artist or group has a numerous amount of albums and every album has many tracks. I create a dropdown menu for the artist but when I do, I get a numerous of the same artist. For example, if I have like 5 Queen albums, the name 'Queen' will appear 5 times in the list like theres 5 different groups called 'Quuen'. What I would like to know is how to get the dropdown menu to show just 1 name and upon clicking that name, the form will goto the first record under that name? So its like a query but it still shows the rest of the records.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Welcome to the Forum....

    In the Row Source property for your Drop Down ComboBox, make sure your SELECT query states: SELECT DISTINCT instead of just SELECT. would look something like this:

    SELECT DISTINCT artists FROM AlbumsTable

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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