Three Combo boxes . One Control Source

[peterjm]

I have three combo boxes, I want to populate them with different data from the same control source from a many to many relationship. example customer has many sales people assigned to them and many sales people have many customers.

I want to set up three combo boxes to select sales people for the customers and not have to use the continues form as it suits my application better. I assume this has to be done with code, i am just learning code so don't know how to do this.

any input would be greatly appreciated.

Peter

[Stang02GT]

I'm a little confused on what you are asking...

do you want the selection of one combo box to filter your options in the other boxes?


Example:

1st Box has Manufacture
2nd Box has products, and based off which manufacture you select will determine what products are displayed in the box

[peterjm]

I'm a little confused on what you are asking...

do you want the selection of one combo box to filter your options in the other boxes?


Example:

1st Box has Manufacture
2nd Box has products, and based off which manufacture you select will determine what products are displayed in the box

The Customer is displayed from the customer table no combo boxes, then create a combo box that pulls from a query/listbox of employees that a specific to sales type "Inside sales" then create another combo box that pulls from a query/listbox of employees that are sales type "outside sales" and so on. so the combo boxes are pulling info from employees table through a query that narrows down the available employees.
so an example would be
Customer abc is displayed and using the first combo box i can select a designated outside sales person from a drop down. The second combo box does the same but for a specific inside sales person. adding the ids to the link table customeremployees table.
the problem i am having is the the control source in access is the same so the combo boxes are not independant of each other, that is where i think code could help me but am a bit flustered at this stage.

thanks in advance for any suggestions.

Peter