filtering a list field based on another list field

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

Answer 1

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

---

-Tom. Microsoft Access MVP

Answer 2

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  

Answer 3

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

Answer 4

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 

Answer 5

>>>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

Answer 6

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

Answer 7

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

Answer 8

thanks