Unanswered: filter only changes after second query run
I have a form on which there are choices for the user to filter and sort. All is well, but not really.....
If the user chooses a filter from one particular combo box instead of *, the report runs fine. But, a subsequent report where the user want the cbobox to be * runs with the previous filter option. If they try it once more, the filter * will work. ??????
I rerun all of my queries in the click event for running the report, so the data should be fresh. I have tried setting the cbobox to * or null in code after the report opens, but I still have the same problem. I am at a loss. Any help is appreciated!