>Up front info:
>
>1. Parent - Child form.
>2. Both parent and child data sources are indexed views with optimistic table buffering
>
>The child data is in a grid. Just below the grid I have 2 command buttons for adding and removing child records. The remove button has the following code:
>
>
>SELECT RetrofitDetailView
>
>IF !EOF()
> ?? CHR(7)
> mndelete=MESSAGEBOX(" Do you wish to remove "+CHR(13)+;
> "this item from the retrofit?",4+32+0,"Remove Item?")
> IF mndelete=6
> DELETE
> ENDIF
> ThisForm.LockScreen=.T.
> This.Parent.grdRetroDetail.Refresh
> This.Parent.grdRetroDetail.Column1.SetFocus
> ThisForm.LockScreen=.F.
>ENDIF
>
>
>The code works fine in that the record is deleted but the grid doesn't refresh. If I take focus away from the form, say by clicking in the command window, and then click back on the form the grid refreshes and the deleted record is no longer seen. Any ideas on why this is happening and how to correct? TIA
Colin,
If it's not tableupdate() issue (sounds to me) try not using lockscreen.
Cetin