>Jim, I've been using the Requery("TheView") to update the data in the view, but recently discovered the Refresh() function...are you implying that Refresh() is only applicable when a row changes...not when adding a row? it seems like it is much faster to just update a row, rather than the whole view.
>
>>Jill,
>>
>>Before you refresh the grid you need to Requery("TheView")
Jill,
The grid's Refresh will refresh the display of data in the grid. It will not "refresh" the contents of the view. To get the view to have the newly appended record you must reissue the SELECT command associated with the view and that is what Requery() does. You probably need both of them;
Requery("TheView")
Thisform.Grid1.Refresh()