>Hi all,
>
>Could anyone tell me how to refresh a grid after a record is deleted, which has a view as it's record-source, and all rows of the view are not represented in the grid. Using a requery after setting the recordsource to '', then setting the recordsource to the view again, does not show the relevant changes on the grid, besides causing a distortion to the order and the controlsource of the columns.
>
>Thanks very much.
>
>With best regards,
>
>Steve.

with REQUERY() the setting the recordsource to '' is not necessary.

try:

REQUERY()
grid.Refresh
grid.SetFocus