>Naomi:
>
>One other question, when I requery, it adds the new records to the old ones so the grid keeps getting longer and longer.
>
>Is there something I can use like on the click event:
>
>clear grid
>select view
>requery
When you requery your view, the view only has records that satisfy the where condition (parameter). Every time before you requery() make sure, the view parameter is set correctly. If your grid is tied to that view (e.g. grid's recordsource = view name), you don't have to do anything special.
If your grid's record source is updatable cursor, you may want to select that cursor and use ZAP command to get rid of all records.
If it's not broken, fix it until it is.
My Blog