I have two combo box on the main form and both with a Value List for the Row Source Type.
The first combo box name is Project and the second one is Inspector.
Right now, when I select a project from cboProject, the subform will be filtered only for the selected Project. Same thing goes when I select the Inspector names.
Now, I want the Inspector combo box be controlled by the Project combo Box.
When I select a project, I want the Inspector combo box to only show the related Inspectors and filter the subform.
I have searched for reference but I couldn't find any cascading combo box reference for Value List Type. I can't add query for Value List.
Any idea how?
And how can I make it a two ways cascading combo box?
For example, when I select an Inspector, the Project combo box will also be filtered.
The first combo box name is Project and the second one is Inspector.
Right now, when I select a project from cboProject, the subform will be filtered only for the selected Project. Same thing goes when I select the Inspector names.
Now, I want the Inspector combo box be controlled by the Project combo Box.
When I select a project, I want the Inspector combo box to only show the related Inspectors and filter the subform.
I have searched for reference but I couldn't find any cascading combo box reference for Value List Type. I can't add query for Value List.
Any idea how?
And how can I make it a two ways cascading combo box?
For example, when I select an Inspector, the Project combo box will also be filtered.