>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?
Most likely, you could check if 'SomeValue' is already in the condition and replace that part of the string instead of adding to it. You could keep list of conditions in the cursor, so checking could be easier.
Edward Pikman
Independent Consultant