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