I have built a report where the value selected in the first combo box fillters the choices available in the 2nd combo box. This all works fine with the "requery" VBA coding, but I have one problem. When I select the value in the 2nd combo box (from all the values) that specific record isn't pulled. All the records for the combo box values are pulled.
My combo boxes are 1.) State and 2.) School
The user chooses the state in cbo 1 and based on the value gets a set of schools to choose from in cbo 2.
Please help.
Brad