Unanswered: I want a combo box to display specific data based on a selection from another combo
I have an error tracking database that uses a 5-tiered methodology (What type of error, what group, what department, the source, and the detailed reason). Each Tier has a combo box that pulls options from a table. Based on the group I select, I only want certain options to appear in the department combo box. Is there a way to do this in Access?