Ideas on how to better accomplish this

[spectraflame]

I have a form that allows the user to populate a combo box (cboDept) of the desired department based on a query. Once that department is chosen, I have another combo box (cobInven1) that executes a query based on the department. The contents of this box display inventory items for only that department. I then have another combo box for order classification (cboClass1) with the choices of Maintenance or Capital. I now need to populate a Item Charge Code combo box (cobItemCharge1) and an employee labor number combo box (cboLabor1) based on all of these items.

I hope this makes sense.

If I choose Electric for my department, the only Inventory items that I can select are from the Electric department. Then I will select Maintenance for the job classification. Now my ItemCharge1 box is populated with the charge number for my specific inventory item for a maintenenace order and my labor box is populated with the larbor charge numbers based on the inventory item and the classification.

I already have an inventory table that lists the inventory item, description, maintenace charge number, and capital charge number. I also have a table for Labor based on job classification and department.

I hope that this is somewhat easy to understand. Any suggestions would be appreciated. I have tried writing queries that would refresh based on content of other combo boxes, but I have not been successful.

Thanks,
Matthew

 

[HomerJ]

Hi Matthew.

Are you looking for something along these lines?

http://www.mrexcel.com/board2/viewtopic.php?t=94118
or
http://www.mrexcel.com/board2/viewtopic.php?t=139321

 

[spectraflame]

Actually the first link will point me in the right direction. I realize that I am asking a lot of the application and things could be simplified by just having my users choose items from a large combo box, but my users are lazy.

Thanks again,
Matthew