>>>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
Not sure about this in VFP but you are probibly still sittin on the deleted record. Try going to a new record with skip or something .
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn