Hi Barbara,
Long time no see!
I have a similar problem with deleting a record, but from a buffered data environment in my form. I created a new record. I save the new record with TableUpdate. I then want to delete it. The buffering is set to 2-Pessimistic Row Buffering. When I use the PACK command, the record will seem to be deleted, because my record count even changes from 3608 to 3607. However, when I exit the form and come back, my record count is now 3608, and the deleted record is back. I have a flag set to make a label called lblDeleted display the caption of "Deleted", if a record is marked for deletion. Well, the record is certainly there. Why is it not really deleted after the PACK command?
Do I need to set the table cursor to a different buffering mode or turn it off, or what? Do I need to save the deletion, then PACK the table?
Cecil