Requery problem, closing my RecordSet

[MaBen]

Thank's Paul

But it's not working,
The stat or rsTemp after Delete stored procedure is close.
And subtracting 1 from recordCount will work, but I need more than just the RecordCount.

The only solution that I found yet is:
Instead of using stored procedure for delete, is using :

rsKM.Delete

and forgot the requery thing.

or

rerun the first stored procedure, that will fill up the RecordSet with fresh data.