>I have a variable, m.FilterCondition, that is built as criteria is selected on the form. For example:
>
>m.FilterConditon = m.FilterCondition + " AND SomeValue = SomeOtherValue01"
>
>This works great until the same condition is selected again:
>
>m.FilterConditon = m.FilterCondition + " AND SomeValue = SomeOtherValue02"
>
>Now m.FilterCondition has both clauses, which causes problems. How can I ensure that I have a good conditional variable?
Pressumably, you have two parts of the condition: a "fixed" part, and a "user-supplied" part. Keep the fixed part in a separate variable (or more likely, form property), and then add the user-supplied conditions. Next time the user selects criteria, add those criteria to the fixed part again.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)