>I've a grid with datasource=view on a normal form. I can select a row in the grid and delete the record in one of the underlaying table. But the grid is not updated while the table is correct. When I close the form and open the form again everything is ok. I've tried something with the refresh events, but no success.
>
>Where is the mistake?
>
>Thanks in adance
>Wolfgang
=REQUERY("myView") && will reset the RECNO to
TOPSo, you need to first carry the RECNO or KeyField and back to that record after REQUERY
CurKey = myView.myKey
=REQUERY("myView")
Locate for myKey=CurKey
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.