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
Rob