Hi Oliver,

Try to make a Parameterized SQL view as your grid.recordsource,

like this,

LOCAL lcCondition
lcCondition="mycondition" &&& or you can add Space(0), or any data type needed

Create SQl View myView as ;
Select a.*,b.* FROM mytable1 a,mytable2 Where a.myfield1=b.myfield2 and;
a.myfield1=lcCondition

Use this View as Grid.recordsource

So you can change the condition each time you needed by :

Local lcCondition
lcCondition="anyCondition"
=Requery(grid.recordsource)
grid.refresh()

HTH