>>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?
>
> did you try to .REFRESH() the list box
>
>Arnon
Also try setting DELETED ON, a requery will still pull in deleted records.
HTH,
Greg
** ** ** ** ** ** ** ** ** ** **
Gregory Cummines
Visual FoxPro 3.0/5.0
C/C++ Applications
** ** ** ** ** ** ** ** ** ** **