I am trying to make a triple combo-box where the user will select values from the following:
Directorate
Department
Division
Once the values are selected the user will click the “run query” button and only those records with the selected values will show.
For example, in the attached database if the following are selected:
Directorate: CAN
Department: 3
Division: 5
Only those records (five of them) with those criteria would be shown (isolated) for the user to interface with. There will be thousands of records in this database in time.
I want to use this action in the Form not a subform/subreport. Is this possible? If so can someone please point me in the right direction? I know that the combo-boxes need to be synchronized, etc… I have found several examples but none of them address my current needs.
Any help with this would be great. Thanks in advance.