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?