Hi Kim

This happened because the variables that made the filter "disappeared" - technical term is went out of scope after the init method finished. You macro substitution is the only way to handle your situation. You might want to consider using views for this. As the table length increases, the performance is going to drop significantly. The grid doesn't consider Rushmore optimization even though the SET FILTER command does. So it'll eventually become as if you are filtering without optimization.

Mike