Hi John,

You mean REQUERY('ViewName') instead of REFRESH('ViewName'), isn't it?

>Hi Don---
>
>Use a parameterized view for the grid, change the parameter and then REFRESH('viewname').
>
>So, for example, if you had lineitems for an order in a grid, the view would be created as:
>

>CREATE SQL VIEW vueLineItems AS ;
>   SELECT * from lineitem WHERE order_no = ?order.order_no
>

>
>Your "Next Order" button might contain code like this:
>

>SELECT order
>SKIP           && Changes to next order
>=REFRESH('vueLineItems')
>THISFORM.Refresh
>

>
>
>>I have a bound grid but I would like to filter what is being viewed. I could use a query of view, but I need to be able to change the WHERE clause then refresh the control. What is the best way to accomplish this?