Custom report with multiple drop down selection query (1 Viewer)

[Officeboy]

Ok, This form is breaking more and more that I try to "fix it", Any suggestions will be helpful.

Basically, how it's supposed to work is this, You select from the "report" at the top and it will list the counties that is available for it.

select the county and it will show you the project trades for the county

you can choose Commercial or Residential or both.

and you hit customize, and a report will show up, ready to go with the project entries.

Now, here's the problems.

1. You can select a county, and no trade, and it will print out the report, if you select a trade, you get an error.

2. you can choose commercial, or Res, or both, and it will update the number of projects next to the county and in the trade field, But if you select if you want active or inactive, or on hold projects, the numbers next to the trades will change, but NOT the numbers next to the counties listed.

3. I think the numbers are not adding correctly, If you select a county, and select "all projects, the number of projects that is printed does not match.

let me know if you see anything wrong, or can help me fix some of the code.


Thank you