When the user has both a item selected in the project number filter and the site id filter, but then changes the project number filter it does not show anything in the data grid.
This is happeneing because of the triggers on the filter combo boxes (to change the items in the datagrid when the filters are changed) when the project number filter is changed, it sets the default value of the site id filter to "" which then triggers the site id filter function and double runs it.
the data grid now does not update twice when the project number filter is changes with something in the site id filter selected. So it updates properly.
When the user has both a item selected in the project number filter and the site id filter, but then changes the project number filter it does not show anything in the data grid.
This is happeneing because of the triggers on the filter combo boxes (to change the items in the datagrid when the filters are changed) when the project number filter is changed, it sets the default value of the site id filter to "" which then triggers the site id filter function and double runs it.
Logic may need to change a bit to fix this.