Hi Wang

I do not understand exactly what you are trying to do.

SET DELETED ON is one way to hide deleted records.

If you Select * from Mytable into cursor Mycursor and them pack mytable, the deleted records in mytable are still in mycursor.

>Hi Mike,
>
>Thank you for the reply. If i don't use pack (Which you are rite that this suppose to be done weekly or a period of time) how i can avoid to display the data from the table which i have deleted.
>
>Also beside this, i found another thing about pack. If i have run the statement as below (which in other button like scrolling)
>
>Select * from Mytable into cursor Mycursor
>THISFORM.Combo1.controlsource = "Mycursor.Myfield"
>
>
>The subsequent pack after the deletion will not take effect at all even i have already put a "select Mytable" before the deletion statement ? Instead, if i just use
>
>Select Mytable
>THISFORM.Combo1.controlsource = "Mytable.Myfield"
>
>Every thing go back to normal.
>
>Why is this cursor thing can affect the pack statement ?
>
>
>Thank you and best regard