>I try to build a simple program which access to MS Access table. After deleting the record from the form, and I call the refresh function in the form. But the data on the form does not refresh according. If i close the form and open again, the deleted record is not shown on the form anymore.
>
>Does anyone knows why the refresh in the form does not refresh the form properly?
>
>More information, I use the remote view for my program.
>
>Thank you in advance.

Move the record pointer off of the deleted record and then issuer DELETE. Deleted records will still show even with SET DELETE ON when the record pointer is positioned on the old record.

DELETE
SKIP
THISFORM.Refresh()