View original (French)

Access dropdown list without duplicates

enlérga -  
 tessel57 -
Hello,

I want to create several drop-down lists in my form that will serve as filters so that depending on what I choose in my list (or lists), the corresponding data will be displayed in the other fields present in my form.

My problem is that in my list, all the data from the column in my table is present, for example:

Project number
7
7
7

135
184
7
135

7

Whereas I would like this type of drop-down list:

Project number:
7
135
184

Thank you in advance!
Configuration: Windows XP Internet Explorer 6.0

6 answers

  1. tessel57
     
    Good evening, if I understood something from your request, you would like cascading dropdown lists such that the data in dropdown list 2 depends on choice 1, the data in list 3 depends on choice 2, etc., and furthermore, the dropdowns only present each value contained in each field once.
    Let's take it step by step:
    1) Dropdowns that present each value from the field on which that list is built only once. You just need to select the "unique values" property in the properties of the underlying query. You will have each value only once even if it appears multiple times in your original list.
    2) For dropdowns with cascading choices; you need to include the name of the field that contains dropdown list 1 among the selection criteria of the underlying query 2, and so on. I'm looking for a way to send you a template.
    2
  2. castours Posted messages 2955 Registration date   Status Member Last intervention   217
     
    Hello
    If you want to perform a selective filter on several fields with dropdown lists, those should come from a table with a one-to-many relationship.
    Then, in a creation mode form, create the independent dropdown lists with the same names as the searched fields.
    Next, create a sub-form using the tool on the table or query regarding the table in question, the table where the relational fields are located.
    1
  3. seblekiller_oupas Posted messages 397 Status Member 5
     
    I didn't understand everything, but if you make a request with your field there with the grouping option, wouldn't that be what you want to achieve?
    0
    1. Brachior Posted messages 616 Status Member 46
       
      I didn't understand the question Oo xD
      0
    2. enlérga
       
      I will explain a bit more...

      I need to create dropdown lists that will serve as cumulative filters in my form, which also contains other fields (all from the same table).
      When I create my list (which allows me to search for data in my table), it shows everything that is in the column of the table. For example, if I have 750 rows in my table, it will display all 750 values in my dropdown list... with all the duplicates!!

      I thought about making this query, but the problem is that my form has my table as its source
      SO this list can only have one of the fields from the table as its source and NOT a query (that's why it shows everything in my list).

      I hope I have been clear, otherwise I'll explain again :)

      Thank you in advance!
      0
  4. jack bauer
     
    For me, it's like in the first response: to eliminate duplicates, you need to put the "grouping" option in your query. Right-click on the "project number" field, there's a "sigma" (sum in math ^^) and you choose grouping.
    tschuss
    0
  6. breizheau
     
    I have exactly the same question....
    0
  7. SteeveGates Posted messages 6 Status Member 1
     
    Hello,

    I have almost the same problem. I am using Access 2010.

    My form is based on a query.

    In the drop-down list of my form, I want to display not
    Steeve Jobs
    Steeve Jobs
    Bill Gates
    Bill Gates

    -but only:
    Steeve Jobs
    Bill Gates

    Is it possible?

    P.S.:
    The idea of grouping from an earlier message, I could apply it to a person identifier, which I hide in the list.

    But I can't find the grouping option in Access 2010.
    0