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
Senna Dwipayana
Being good is better
Being better is a bless