Hi Cheong....
The simple answer would be to SET DELETED ON, which is the proper way to excerpt deleted records. In addition, in a form with Private DataSession, you need to set things like DELETED in context of the form...I usually will put SET DELETED ON in the BeforeOpenTables event of the DataEnvironment on Private DataSession forms.
>Hi, can anyone help me in this?
>I have set the DELETED OFF, but still I can go through the marked deleted records in the form.
>
>Why is it so?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05