I have a problem where I have a parent form (fEditAgreement) and a continuous subform (tTerm_subform) that displays related records. Each instance of the term subform contains an Edit button. When that Edit button is clicked, a new form (fEditTerm) is opened that is filtered to that term. This works fine. However, I also have a delete button on fEditTerm. I currently have the onClick event set to the function below:
Private Sub cmdDeleteTerm_Click()
DoCmd.Close acForm, "fEditTerm"
What ends up happening is that the current record in fEditTerm is deleted, but a blank new record is immediately inserted at the same time. How do I keep that blank record from being inserted?