How to display a list of value based on a combo box

[ezz]

Hi,



I want to create a combo box on a form where I can choose between 5 company names, and upon my choice, I want a list box or another combo box to display the departments under the company I chose (each company has different departments), and when I choose the department, I want to another combo box to display the limited job titles under that department.

For example:
I choose company A > combo box displays the 5 departments under company A (dept.1,2,3,4) I choose dept. 4 > display job titles under dept. 4

How can I do that? Should I do a table? A query?

Please help.

Thanks.

[orange]

Research cascading comboboxes. Here are 2 links to free video to show concepts involved.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[ezz]

Research cascading comboboxes. Here are 2 links to free video to show concepts involved.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

Thank you so much, Orange! This is exactly what I want.

[orange]

Key links for Access issues/questions:

Sample syntax and functions

Allen Browne Tips