Quinn....

When the source is an SQL query, recreating the query when the form is live is not good. Try creating a parameterized view in your database, example:

SELECT * FROM client WHERE name = ?cName

cName = variable holding a name that may change.

Then tie the grid to the view. When you REQUERY the view, refresh the grid. Problem resolved.



>Hi,
>When I use formname.grid1.refresh() after recreating the database using select-sql statements, it turns the grid all white and blank.
>What are we doing wrong????
>
>Please help
>~Quinn