Click to See Complete Forum and Search --> : update the recordset after deleting records


Blue Sky
April 5th, 2001, 03:52 AM
Suppose I have a recordset called rsDelete which is used to delete records in another recordset called rs.

How can I update (refresh) rs to show the status that some records in it are deleted ?

When I used rsDelete.delete to delete records in rs , I found out that those records still in rs!!!

Is there any method in ADO that is similar to rs.Refresh ?

Please teach me

Cakkie
April 5th, 2001, 06:01 AM
You can use the Resync Method of the recordset.

Tom Cannaerts
slisse@planetinternet.be

The best way to escape a problem, is to solve it.