cascading combo box

[kobiashi]

Hi all


I am struggling to understand how to achieve a cascading combo box.

i have three tables

Table_Roles
ID | role |

Table_Department
ID | department |

Table_Roles_Departments
Role_IDFK | Departments_IDFK

and I have created a many to many relationship

when i run the query it returns all the information as it should, but I'm stuck, what do to from here, how do i connect the two cascading combo boxes to the query

 

[June7]

See if this helps http://datapigtechnologies.com/flashfiles/combobox2.html

That tutorial shows comboboxes saving text, not ID primary key. If you prefer to save the ID then that is a combobox with alias and won't work as nicely in continuous or datasheet forms but can be dealt with.

I also recommend code in the second combobox GotFocus event instead.

There are uncountable number of threads on this topic. Have you searched? Exactly what have you tried? What is the exact issue you encounter?

 

[kobiashi]

thank you

this helped