>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?
You need to make sure SET DELETED is ON, and then call the Requery method of the listbox.
Mark Peter
=========================
Mark A. Peter
Los Angeles, CA
mpeter@primenet.com=========================