I have 3 drop down boxes that have code attached to them that filters the data on the form, so that if the user selects Marty, the form will filter for all of Marty's assignments.
They can then select from another drop down box that will further filter (in this example) Marty's projects but using another category.
The issue that I have is that even after I select, for example, Marty, when I go to the next filtering drop down box, that drop down box displays all data for all records. In other words, its data doesn't reflect the filtering of the form caused by the first drop down box selection.
Is there any way I can get the drop down boxes to reflect only data based on the the current form filter?
Maybe something to do with setting the control source of the drop down box to the current form status? Not sure how to do this though?
Thanks for any help..