I set a breakpoint on SET DELETED ON & nothing happened?
Could this be a buffered data problem?
>>My SQL is in a grid form. A Second maintenance form is called based on the current selected record in my grid. Changes are made in the second form & saved . Then I return to my 1st grid form.
>>
>>There is a command button on my first from to delete records.
>>
>>Once a user has made changes using the second form, and I return to the grid form, any records I try to delete are ignored by my SQL command.
>>
>>Hope this makes sense.. phew
>
>It sounds like your second form changes the SET DELETED (and may be other) settings.
>
>Try
>messagebox(set('deleted')) before calling your form and after.
Rob