try breaking the link first, on the sub you are deleting:
private sub form_delete(cancel as integer)
me. parent!otherSub. LinkMastetFields="'
end sub
private sub form_afterdelconfirm(status as integer)
me.parent!othrSub.LinkMastetFields="othersub. Form.YearLevelID"
end sub
I am getting confused. Lets explain more. I have a from which is bound to tblAcadimicYears with two subfroms, the first one is bound to tblYearLevel and linked to the main form via YearID, and the second subfrom is bound to tblYearLevelCourseTeacher. The process of data entry in my form is :
Insert a year to the main from, then insert levels to the first subfrom, and finally, insert YearLevelID, CourseID,TeacherID and Credit to the second subfrom. That is about my from scheme. Now, when I delete a level, then a related records from the second subfrom should be deleted. Actually, the deletion process done with problem unless an annoying "#Deleted" appears in the credit field of the second subfrom before delete confirm message box, so when I click OK, the related records be deleted and the "#Deleted" disappears, also, when I click cancel, the operation be canceled and the "#Deleted" disappears too. I want for that "#Deleted" don't be shown ever at any time and any event.