[AccessD] Closing form problem

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed Jan 6 09:05:07 CST 2016


I have a data entry form tied to a table. When the data entry has been made in the last text box I want to close the form. I have the following event procedure on the exit event of the text box. I get an error message. I am not seeing what I am doing wrong. Thanks.

RunTime Error 2585
This action can't be carried out while processing a form or report event.

Private Sub Not_defined_Exit(Cancel As Integer)
    DoCmd.Close acForm, "frm Cisco Sands Input", acSaveYes
End Sub

I tried adding this but it did not help

Private Sub Not_defined_AfterUpdate()
    DoCmd.RunCommand acCmdSaveRecord
End Sub


More information about the AccessD mailing list