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