G
Guest
Microsoft Access 2002. On a form, how do I control what is displayed in
multiple combo boxes that are dependant upon one another. Example: Creating
a form to input additional employee information. I have a table that
contains Company divisions. Each division has serveral departments. Within
each department their are 10 - 30 employees. On the form, I need to create 3
combo boxes that will draw information from the table. The first combo Box
would list the divisions. Based on the division selected in the first combo
box, the second combo box would list the departments in the selected
divisions. Base on the department selected in the second combo box, the
third box combo would list the employees in the department. All other
information inputted on the form would be information on the employee
selected from the third combo box.
multiple combo boxes that are dependant upon one another. Example: Creating
a form to input additional employee information. I have a table that
contains Company divisions. Each division has serveral departments. Within
each department their are 10 - 30 employees. On the form, I need to create 3
combo boxes that will draw information from the table. The first combo Box
would list the divisions. Based on the division selected in the first combo
box, the second combo box would list the departments in the selected
divisions. Base on the department selected in the second combo box, the
third box combo would list the employees in the department. All other
information inputted on the form would be information on the employee
selected from the third combo box.