The code is working fine however when i use the first form, a prompt pop up opens "Enter Parameter Value" and it asks for the combo box value from the second form and vice versa
Both Combo boxes are in different forms. Form 1 is used to search by officer wise and it has the first combo box, the form 2 is used to search company wise and has second combo box.
I have two combo boxes in different forms
Combo0 has names of the officers
Combo001 has names of the companies.
I want to use both combo boxes as criteria for the query, the problem i face is that i have to select options in both combo boxes to run the query successfully, i want the query to run...