>>>>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 .
Deleting a record in a query doen't mean its deleted in the original table as well. You should issue tableupdate to get the job done. The reason is youre working in a view and not straigth away on the table. In other words your change is buffered.