I answered this for you in another thread. But I wanted to point out that if you surround your code with < pre > and < /pre > tags (without the spaces within the tags), it won't be re-formatted and will be easier to read.
>I have a Grid with Parent-LinkMaster <-> Child-RecordSource relationship. I have a button on Form (.SCX) that Deletes highlighted record in Grid. The row data disappears when I execute my Delete code, but the underlying RecordSource data table is not removing the record deleted through form.
>
>Here is my underlying code:
>
>IF MESSAGEBOX("Delete this EAR Drawing Association?"+CHR(13)+CHR(13)+DD_EarAppDwg.rd_dsort, ;
> d_nQuestionmark+d_nYesno+d_ndefaultsecond,"Delete EAR Drawing Association")=d_nYes
> nSelectWas = SELECT()
> SELECT DD_EarAppDwg
> DO WHILE NOT RLOCK()
> ENDDO
> DELETE
> GO RECNO()
> UNLOCK
> THISFORM.REFRESH()
> SELECT (nSelectWas)
>ELSE
> WAIT WINDOW TIMEOUT 3 "Record Association Not Deleted."
>ENDIF
>
>Can anyone see the problem?
>
>Fred Z