Drop Down Box which effects another Drop down box

[ujpest75]

Hi Access fans

I know it is possible but I cannot for the life of me work out what I am doing wrong. I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc
Any help would be appreciated.
Thank you

 

[rzw0wr]

The 2nd combo box should have a WHERE clause.

WHERE Direction = & 1st combo box Direction

We need to have more information to be more specific.

Dale

 

[jdraw]

see the free video tutorials here
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

Combo boxes related as you have described are called Cascading Combos.