I have a form with a view set up in the data environment. In the data environment's "beforeopentables" event I do "set deleted on".

Even with this, I'm all of the sudden seeing a deleted record show up in the view based on a record from a table that I manually opened and deleted the record from. I've been deleting records from this table manually for some time, and I've never run into this issue before.

How can I keep the deleted record(s) from showing up in the view.

thanks,

Jim Erwin