Combobox fill based upon value from another combo box 1

[joshuaz]

I am trying to set up a form where I can select a record on an employee table based upon a series of combo boxes that feed off each other. For example, if my first combo box is a list of "Employee Departments" and the value selected by the user is "MIS", then the second combo box (which will be "Employee Title", should only display values of employee titles which relate to the "MIS Dept", for example, DBA, Programmer, Analyst, etc.. It should not display "Accountent" who woulds be from a different department.

This is probably an easy one, but I have been having a hard time with this.

Can someone help me with this.

 

[WildHare]

I have a sample db on my site with this very task as an example. Just grab it , see the miniscule amount of code that's needed, and you should be good to go.

http://www.jmhare.com/wildhare2.htm

I think it's about the 8th or 9th down the list - look for "using one combo to restrict choices in 2nd combo"..

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm