you could compute the number of non deleted records using the statement
count(*) for not deleted() to nCount
nCount now contains the right number of records.
HTH,
Marc
>In a form, I have a grid (record source is Table A), a delete button to delete a record and a label to show the total no. of record (by using reccount())
>I want to use the label to show the most update of no. of record.
>My problem is if I add "pack" after my delete code, it will make my grid become blank.
>If I don't add "pack" to my code, the label will show the no. of record including the deleted record. So what can I do?
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.