Ok I have a problem here I am using MS Access 2010 and I have 1 form with 8 combo boxes in it below I will explain what I would like to happen and what is happening instead
What I am trying to do is use the after_update feature in the event tab under properties (at least I think that is what I need to use)


Tables

1. tbl_department
2. tbl_job_title
3. tbl_category
4. tbl_sub_category
5. tbl_item
6. tbl_size
7. tbl_discription
8. tbl_price

Form

1. Equipment assignment

What is happening:
When I select the cbo department I can select any of the departments (i.e. HR, Admin, billing.) and when I select cbo job title I can select positions that are not even associated in any manner with the department I selected. This is happening in all of my cbo's.

What I would like to happen:

Here is what I would like to happen on the form when I open the form the only combo box that can be selected is Department. When I open the combo box and make a selection I want the Job title cbo to become selectable and only be able to view items associated with the department I selected. Upon Selecting the Job title I then want cbocategory to become selectable. I would like this feature to continue right down the line until the last combo box.

BTW I am new to VBA and I am still trying to fully learn Access 2010 any help that is given will be greatly appreciated.

Hi
Check out this link in reference to: Cascading Lists for Access Forms
HTH's