By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,945 Members | 1,692 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,945 IT Pros & Developers. It's quick & easy.

Three Combo boxes . One Control Source

P: 2
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
Jul 18 '07 #1
Share this Question
Share on Google+
2 Replies


Stang02GT
Expert 100+
P: 1,208
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
Jul 18 '07 #2

P: 2
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
Jul 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.