>>You're right..it does have to do with table relationships... I just recreated this in the command window with two other views. One, which had multiple tables with persistent relationsips, behaved the same way. The other, with only one table, behaved as expected (ie returned records the first time).
>>
>>I'd like to understand what is happening here if anyone can explain it.
>
>Did you try resetting the parameters(s) before requery()? Also, are any of the base tables buffered? (Just some vague ideas now :)

The parameter is restated before the delete. The base table is not included in the DE and is implicitly unbuffered.(I even tried it with a tableupdate of the base table which gave me the 'no buffering' error message)

I still think this has something to do with the fact that these are multi-table views even though only one table in the view is updateable. I cannot replicate this behavior on a single table view.

My faith is beginning to be challenged...

Terry