I have a list box based on a table. The user can choose to delete a record from the list box. After I used a SQL statment to delete the record, it still appears in the list box even though I REQUERY the form. I tried the PACK command, but it will close all my table and the entire list box becomes blank.

How do I REQUERY the table from a list box after I deleted a record?