none
filtering a list field based on another list field RRS feed

  • Question

  • hi:

    i have 2 dropdown list. what i want to do is when i select a value in field1 then field2 well show me the related value for field1

    example:field1 have the values 1,2,3 and field2 have the values a,b,c,etc'

    when i select 1 it well show me in field2 the value that i declare for "1" let's say  a,b,c

    now i want to do at on a criteria builder. not on a form afterupdate

    Sunday, June 19, 2016 10:22 PM

Answers

  • i know this method.my question is can i do it in the table or the query by the expression builder

    No.  As Tom pointed out earlier, interface elements are controls in forms not in tables or queries.

    Ken Sheridan, Stafford, England

    • Marked as answer by eshay1 Tuesday, June 21, 2016 7:01 PM
    Tuesday, June 21, 2016 3:47 PM

All replies

  • That feature is called "cascading dropdowns". Search for it using your favorite search engine.

    -Tom. Microsoft Access MVP

    Sunday, June 19, 2016 10:24 PM
  • That feature is called "cascading dropdowns". Search for it using your favorite search engine.

    -Tom. Microsoft Access MVP

    thanks for the replay

    i meant if i can do it on a query by using the builder  

    Monday, June 20, 2016 12:04 AM
  • I'm not sure what you mean. Can you please explain, and perhaps include a screenshot?

    Note that UI elements like cascading dropdowns live in Forms, not anywhere else like in queries.


    -Tom. Microsoft Access MVP

    Monday, June 20, 2016 12:30 AM
  • I'm not sure what you mean. Can you please explain, and perhaps include a screenshot?

    Note that UI elements like cascading dropdowns live in Forms, not anywhere else like in queries.


    -Tom. Microsoft Access MVP

    i'll explain. i have a table that 2 fields called "main Classed" and secondary Classed"

    i build on this table a queries and on this queries i build a diffrent forms 

    for now i have to choose in the "main Classed" and then i have to look in the  

    "secondary Classed" the value that mutch. and it's a long list 

    so what i need that if i choose value in "main Classed" the "secondary Classed" well auto

    filter the value that belong to the  "main Classed" value 

    now i don't want to do it on the form because i have a lot of form.so can i do this in the main  querie with the code builder 

    Monday, June 20, 2016 2:18 AM
  • >>>now i don't want to do it on the form because i have a lot of form.so can i do this in the main  querie with the code builder 

    According to your description, you could synchronize two combo boxes on an Access form, follow below two steps:

    1. Add an event procedure for the combo box AfterUpdate event.

    2. Add code to the AfterUpdate event procedure that updates the contents of a combo box based on the item selected in another combo box.

    For more information, click here to refer about Synchronizing Combo Boxes on Forms in Access 2007

    Tuesday, June 21, 2016 7:09 AM


  • According to your description, you could synchronize two combo boxes on an Access form, follow below two steps:



    tnx

    i know this method.my question is can i do it in the table or the query by the expression builder

    Tuesday, June 21, 2016 1:42 PM
  • i know this method.my question is can i do it in the table or the query by the expression builder

    No.  As Tom pointed out earlier, interface elements are controls in forms not in tables or queries.

    Ken Sheridan, Stafford, England

    • Marked as answer by eshay1 Tuesday, June 21, 2016 7:01 PM
    Tuesday, June 21, 2016 3:47 PM
  • thanks

    Tuesday, June 21, 2016 7:00 PM