I have created a listbox that will filter a report based on its contents. There are times that I want to further filter the report by only allowing the report to show the listbox contents when their status = 'x'.
So, as an example, if there are 3 records in the listbox and I click 'cmdFilter', the report will show all three records. If I select a checkbox, then I would expect to see only two records (as they both have a status = 'x').
For some reason, this filter only works the first time. If I don't use the checkbox, the filter will work each time. If I want to use the checkbox, it will only work the first time.
I would appreciate any thoughts that you may have...I am stumped!
So, as an example, if there are 3 records in the listbox and I click 'cmdFilter', the report will show all three records. If I select a checkbox, then I would expect to see only two records (as they both have a status = 'x').
For some reason, this filter only works the first time. If I don't use the checkbox, the filter will work each time. If I want to use the checkbox, it will only work the first time.
I would appreciate any thoughts that you may have...I am stumped!