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)
- 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.