I'm not skilled in the ways of VB so I hope the answer involves a query and/or macro.
On my form I have two combo boxes one has a list of offices in my company. The other has 42 categories the company can spend from. The problem is that I would like to limit the choices a person has in the 42 category box based on what they choose from the other drop down box. Please keep in mind that each office has several things to choose from in the second combo box.
So basically I want to base the contents of one combo box on what is entered in the other combo box. So, if someone enters in "LGMW" in the first combo box that should reduce the second combo box from 42 to a few items that's only specific to "LGMW."
I think I make it sound more complicated than it really is.
On my form I have two combo boxes one has a list of offices in my company. The other has 42 categories the company can spend from. The problem is that I would like to limit the choices a person has in the 42 category box based on what they choose from the other drop down box. Please keep in mind that each office has several things to choose from in the second combo box.
So basically I want to base the contents of one combo box on what is entered in the other combo box. So, if someone enters in "LGMW" in the first combo box that should reduce the second combo box from 42 to a few items that's only specific to "LGMW."
I think I make it sound more complicated than it really is.