Oh, right....duuuhhhh....you knew what I meant, Bob :-D

>>Strange --- OK, here's what I did:
>>
>>SET DELETED OFF then opened the view ... shows 6 records, none deleted (4 of the base table records are deleted). Did not requery, though....
>>
>
>John... you may be thinking in reverse though...
>
>remember:
>
>SET DELETED OFF - SHOWS/PROCESS DELETED RECORDS
>
>SET DELETED ON - HIDES DELETED RECORDS
>
>BOb