>>>I have a form that refuses to not show deleted record! I've tried including SET DELETED ON everywhere but deleted record continues to show for whatever reason. This particular table is for testing only and there is only 1 record in the table and the record IS definitely DELETED (I know because I've deleted it hundred times now) but the form continue to display this record. It's very frustrating. I have many other forms that does not exibit this behavior. Does anyone have any good suggestion why?
>>>
>>>TIA
>>>John
>>
>>John :
>>
>>Ensure that you SET DELETED ON in the Init Method of your form. Many environmental settings (including SET DELETED are scoped to the DataEnvironment.
>>
>>Ed
>
>Ed,
>As I said originally, I did try putting SET DELETED command everywhere, including the Init method of the form but it doesn't work. Actually, I've found out you must put the command in the BeforeOpenTable method of the DE in order for this to work. Thanks anyway.
>
>John

John, if you re-set the record pointer (GO TOP, etc.) after the SET DELETED command it will take effect in the INIT as well.

Barbara