Report / Form Correlation

[CLSWL]

I have 2 forms and a report.

Things occur in the following sequence...
Form filter report: allows the user to pick the data that will show up on
the report.
Report: automatically opens sort form
Sort Form: Allows user to sort the report. When the sort button is clicked
the report automatically opens and closes (OrderBy is being changed),
applying the sort.

Problem: The Filter Report form filters the report properly. The Sort Form
sorts the report properly, BUT all three don't work well together.
After 3 sorts there is an error "filter is too long".

For some reason when the report is closed and opened the filter looks like
this:
"Filter AND Filter"

then after another time

"Filter AND Filter AND Filter"

then there is an error because the filter would be too long.


How can I capture this error and fix it?