John,
How do you requery the view? Please give an example in code.
I am having trouble with this and so far I have created the view again (with a different whereclause), set the grid's recordsource to the view and 'reformated' the headers, columnwidth and so on. It works but it seems to me that a single command like requery would be faster (if the grid keeps its layout).

/Pierre Unge, Sweden


>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